[postgis-users] How to setup a versioned datastore?

[Mauricio Miranda]

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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users