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

George Silva georger.silva at gmail.com
Tue Aug 3 07:33:43 PDT 2010


Since PostGIS 1.5, there is a implementation shipped with the software.

Check out PostgreSQL folder under share\contrib\Postgis1.5\ and there might
be a folder history-tables, which contains all the scripts needed to track
changes in a table.

George

On Tue, Aug 3, 2010 at 11:22 AM, Dominik Wiedner <DominikWiedner at web.de>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
>



-- 
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100803/f9772d62/attachment.html>


More information about the postgis-users mailing list