Delivery-Date: Sat, 28 Aug 93 03:06:33 PDT
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9308281001.AA07031@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Sat, 28 Aug 93 19:11:21 jst
From: wolf@molout.tutkie.tut.ac.jp (Wolf-D. Ihlenfeldt)
Message-Id: <9308281011.AA03495@molout.tutkie.tut.ac.jp>
To: postgres@postgres.berkeley.edu
Subject: Is there such a feature ?
Resent-To: postgres-dist
Resent-Date: Sat, 28 Aug 93 03:01:47 PDT


I am using Postgres4.1 on Sparc.

I have a control table Control, which stores attributes of other tables.
I would like to have an automatic update of the control table 
whenever one of the other tables is destroyed. Something like

define rewrite rule Destruction is on destroy to TableX do delete Control where Control.relname = "TableX"

Unfortunately (and its documented) you cannot define rules on  'destroy'
events, only on retrieve,replace,delete and append. Did I overlook
something or can we expect this feature in 4.2 ?

But I do not need only the control table cleanup, but those 
extra tables have also attached directories in the inversion
file system, named something like /TableX. I also would like to 
clean up these directories on destruction. It seems you have to
use currently the p_* routines in libpq to do this - you cannot formulate a
PostQuel query to remove the directories and their contents - 
or can you ?

WDI