Perform an action on schema drop

From: Kieran McCusker <kieran(dot)mccusker(at)kwest(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Perform an action on schema drop
Date: 2008-03-11 12:54:41
Message-ID: 47D68111.1000101@kwest.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

We use schemas to partition the database into client jobs, with public
tables knowing about client. I would like to
update the public tables if we remove a schema but cannot find a way to
do it - I have tried triggers (not allowed)
and a delete rule but all to no avail.

Is this possible?

Many Thanks

Kieran

Browse pgsql-admin by date

  From Date Subject
Next Message sathiya psql 2008-03-11 13:44:19 list user created triggers
Previous Message frant101 2008-03-11 08:38:47 Re: Reindex + relation doesnt exist