Re: [GENERAL] databse version

2013-06-11 Thread Philipp Kraus
On 2013-06-11 00:42:59 +0200, John R Pierce said: On 6/10/2013 12:52 AM, Philipp Kraus wrote: 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

Re: [GENERAL] databse version

2013-06-11 Thread Luca Ferrari
On Mon, Jun 10, 2013 at 9:52 AM, Philipp Kraus wrote: > Hello, > > I'm creating a database and I have got a table with a "version" field. Not sure, but if the version field is something like the version row indicator used by some frameworks (e.g., Hibernate), then you are going to place the updat

Re: [GENERAL] databse version

2013-06-10 Thread Scott Marlowe
We use this system for versioning: http://pyrseas.wordpress.com/2011/02/18/sql-database-version-control-%E2%80%93-depesz-versioning/ Works like a champ. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpre

Re: [GENERAL] databse version

2013-06-10 Thread John R Pierce
On 6/10/2013 12:52 AM, Philipp Kraus wrote: 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 change

Re: [GENERAL] databse version

2013-06-10 Thread Adrian Klaver
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