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.

EBMB <eduardo.bmbarbosa (AT) gmail (DOT) com> wrote:
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