On 08/29/2014 11:23 AM, Patrick Dung wrote:
Hello Postgresql users,
Is there a function to save schema history internally?
By keeping the schema history inside the DB, we can keep track of what
and when is changed in the schema.
While searching google. It seems it is a limitation with the audit trigger:
https://wiki.postgresql.org/wiki/Audit_trigger#Limitation:_Cannot_audit_DDL
Well going forward, 9.4+, there are EVENT TRIGGERS
http://www.postgresql.org/docs/9.4/static/event-triggers.html
For a recent thread on what is possible or not see:
http://www.postgresql.org/message-id/20ee50f73664e744af948f0106fe6dfa585a7...@seambx01.sea.corp.int.untd.com
Thanks and regards,
Patrick
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
