Postgres Pro
Downloads
Home   >   mailing lists

Catching DDL events (or equivalent functionality) - Mailing list pgsql-hackers

From Master of the beasts
Subject Catching DDL events (or equivalent functionality)
Date
Msg-id 200504052037.j35KbnFF021713@dep4.fciencias.unam.mx
Whole thread Raw
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Terry Yapt
Date:
Subject: Re: Should we still require RETURN in plpgsql?
Next
From: John A Meinel
Date:
Subject: Re: Recognizing range constraints (was Re: [PERFORM] Plan