<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I think triggers may not be the answer here. If you define the trigger
as updating the geometry whenever the attributes change then if you
change the geometry the trigger will always reset the geometry to the
old value. The same thing happens if the trigger goes the other way.
I think what ever you use to update the geometry needs to also update
the attributes.<br>
<br>
Bruce<br>
<br>
Matias Massigoge wrote:
<blockquote
cite="mid:f3853bdf0805231257l3972cb98m8a2d6ab8a7b9dc2@mail.gmail.com"
type="cite">
<pre wrap="">John
I'think you need to define trigers in the updates of the table. In
this triguers you should update the fields inspecting the new value of
de Geometry.
Hope this help you.
Matías
On Fri, May 23, 2008 at 4:48 PM, John Callahan <a class="moz-txt-link-rfc2396E" href="mailto:john.callahan@udel.edu"><john.callahan@udel.edu></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Please excuse my question if it seems too trivial. I am just getting
started with PostGIS and couldn't quite find what I was looking for.
For a point data set, it is common for us to store the lat/long (or
easting/northing) as attributes in the table. (Some programs we have require
this.) However, when I edit the position through a GIS (like QGIS), the
spatial location is altered but obviously not the attributes. And when
these attributes are altered in the table, the geometry is not updated,
obviously. Is there a way to keep these synchronized? Is this built into
PostGIS?
Thanks for your help. Even is you don't know how this could be done, is it
possible?
- John
****************************************
John Callahan
Geospatial Application Developer
Delaware Geological Survey
University of Delaware
227 Academy St, Newark DE 19716-7501
Tel: (302) 831-3584
Email: <a class="moz-txt-link-abbreviated" href="mailto:john.callahan@udel.edu">john.callahan@udel.edu</a>
<a class="moz-txt-link-freetext" href="http://www.dgs.udel.edu">http://www.dgs.udel.edu</a>
****************************************
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>