Postgres Pro
Downloads
Home   >   mailing lists

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

Is there a function to save schema history internally?

From
Patrick Dung
Date:
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:

Thanks and regards,
Patrick

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

From
Adrian Klaver
Date:
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@SEAMBX01.sea.corp.int.untd.com


>
> Thanks and regards,
> Patrick


--
Adrian Klaver
adrian.klaver@aklaver.com

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

From
Patrick Dung
Date:
Hi Adrian,

Thanks for the info.

Thanks and regards,
Patrick


On Saturday, August 30, 2014 5:28 AM, Adrian Klaver <adrian.klaver@aklaver.com> 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@SEAMBX01.sea.corp.int.untd.com



>
> Thanks and regards,
> Patrick



--
Adrian Klaver
adrian.klaver@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