Re: Is there a function to save schema history internally?

[Patrick Dung <patrick_dkt@xxxxxxxxxxxx>]

Hi Adrian,

Thanks for the info.

Thanks and regards,

Patrick

On Saturday, August 30, 2014 5:28 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

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/20EE50F73664E744AF948F0106FE6DFA585A790C@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

>
> Thanks and regards,
> Patrick

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general