On 06/10/2013 12:52 AM, Philipp Kraus wrote:
Hello, I'm creating a database and I have got a table with a "version" field. Can I update on structure changes (DDL) like create / update table increment this field automatically? I would like to create a versionizing for my database which counts the changes. IMHO I need a trigger, which is run if a DDL statement is fired on the database
In the current beta 9.3 there are event triggers that would seem to be what you are looking for:
http://www.postgresql.org/docs/9.3/static/event-triggers.html
Thanks Phil
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general