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

George Silva georger.silva at gmail.com
Tue Aug 3 09:17:13 PDT 2010


Hello Mark,

Check the SVN

http://svn.osgeo.org/postgis/tags/1.5.1/extras/history_table/

On Tue, Aug 3, 2010 at 12:57 PM, MarkW <mark.wimer at gmail.com> wrote:

> Hi George,
> I see in the release notes that this was added, but the files are not
> there in my 1.5 install.
> Was there some choice during install that led to files being absent?
> More important, where
> can I get the history-tables scripts?
> Thanks!
> Mark
>
> On Tue, Aug 3, 2010 at 10:33 AM, George Silva <georger.silva at gmail.com>
> wrote:
> > 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
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > 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/f7b448ef/attachment.html>


More information about the postgis-users mailing list