Hi Dominik, The way we use to manage data versioning is:
* Add "created_at" and "updated_at" columns * Create triggers to update automatically these columns on insert and update statements. I think this a common process in any kind of data structure. If you don't want to update (replace) the original data you can copy the record to another table adding a foreign key to the main table record. That could be done inside the trigger function. I hope it helps. Cheers! -- Mauricio Miranda Software Engineering Manager http://www.xoomcode.com On Aug 3, 2010, at 11:22 AM, Dominik Wiedner wrote: > Hello George, > > What I think of is to keep track of the changes made within a table. > For instance: If a row is altered, that row will be copied, so that you have > an unaltered original and an altered version. > > Dominik > > >> Hello Dominik, >> >> What do you mean by versioned? Please explain - as PostGIS has a logging set >> of functions, but not versioned databases. > >> Are you referring to PostGIS History Tables or something else? > >> George > >> On Tue, Aug 3, 2010 at 4:20 AM, Dominik Wiedner <DominikWiedner at web.de >> <http://postgis.refractions.net/mailman/listinfo/postgis-users>>wrote: > >>> / Hi there, > />>/ > />/> Currently I try to set up a versioned PostGIS-Database, but I don't know > />/> which columns have to be added to the table containing the editable data. > />>/ > />/> Could anyone please help me? > />>/ > />/> Regards, > />/> Dominik Wiedner > />/> _______________________________________________ > />/> postgis-users mailing list > />/> postgis-users at postgis.refractions.net > <http://postgis.refractions.net/mailman/listinfo/postgis-users> > />/> http://postgis.refractions.net/mailman/listinfo/postgis-users > />>/ > / > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
