Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Control table changes

0 views
Skip to first unread message

EBMB

unread,
Jun 24, 2009, 1:17:19 PM6/24/09
to
Hello all,
I would like to know if it is possible to control changes in the
structure of a table...

I tried to make a trigger to monitor the updates in the table
pg_attribute. Example: when a column is created that table is updated,
but the system tables do not accept triggers. :-(

Someone would have any suggestions?

Thanks in advance!

Cheers,
Eduardo.

Andreas Kretschmer

unread,
Jun 25, 2009, 2:02:54 AM6/25/09
to

There is no simple way to do that, but you can log all DDL-commands with
log_statement = 'ddl'
in your postgresql.conf to log all such statements.


Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

0 new messages