Catching DDL events (or equivalent functionality)

From: Master of the beasts <dario(at)ciencias(dot)unam(dot)mx>
To: undisclosed-recipients: ;
Subject: Catching DDL events (or equivalent functionality)
Date: 2005-04-05 20:37:49
Message-ID: 200504052037.j35KbnFF021713@dep4.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

I know that you can not (and maybe should not) install triggers
on system catalogs. But, if I want to catch certain DDL events
(such as adding a column), is there any way to do it in PostgreSQL?

Maybe, it could be useful that the triggers (installed on normal tables)
can be fired not only by DML but by DDL events.

Thanks in advance.

Regards,
The F. Jackal.

Browse pgsql-general by date

  From Date Subject
Next Message Werner Bohl 2005-04-05 21:04:29 Out of memory error on select
Previous Message Magnus Hagander 2005-04-05 20:30:38 Re: cygwin and psql

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2005-04-05 21:45:41 Re: REINDEX ALL
Previous Message Alvaro Herrera 2005-04-05 20:32:11 Re: Call for objections: merge Resdom with TargetEntry