[postgis-users] Live PostGIS Edit tool?

[Pedro Martinez Arbizu]

Hi Stanley,
I dont know if I got the problem...
Why you don't just query your database (select from your Postgis table
just the row you need), and then edit the geometry only from that
record. I am using Qgis to do this. If you limit your layer to just
the line/polygon you want to edit, should work quite fast.

Pedro


2008/10/31 Sufficool, Stanley <ssufficool at rov.sbcounty.gov>:
> So far all the tools I have worked with (OpenJUMP, uDIG) use a check out,
> check in process on PostGIS to update geometries. This is impractical and
> sometimes impossible with these tools when dealing with hundreds of
> thousands of records to re-write the entire table to update one
> linestring/polygon.
>
> What I am looking for is a live editor that will post the changes to only
> the geometry row I am working with instead of caching the changes. I can
> record the versions of this data for UNDO at the database with triggers, so
> the check-in/check out is irrelevant at the client since I can roll back any
> user changes to any point in time at the db layer.
>
> Anyone know of such a tool or am I going to have to roll my own?
>
> Stanley Sufficool
> Systems Analyst
> San Bernardino County
> 909-387-2102
>
> P  Please consider the environment before printing this e-mail or its
> attachment(s)
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



-- 
Prof. Dr. P. Martinez Arbizu
DZMB-Forschungsinstitut Senckenberg

Suedstrand 44
D-26382 Wilhelmshaven
Germany

Tel: +49 (0)4421 9475-100
Fax: +49 (0)4421 9475-111

Email: pmartinez at senckenberg.de