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

MarkW mark.wimer at gmail.com
Tue Aug 3 09:32:54 PDT 2010


Perfect. Thanks!
Mark

On Tue, Aug 3, 2010 at 12:17 PM, George Silva <georger.silva at gmail.com> wrote:
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



More information about the postgis-users mailing list