[postgis-users] Link beween the_geom of 2 tables

Richard Greenwood richard.greenwood at gmail.com
Fri Jul 19 06:54:55 PDT 2013


You could do that with triggers but I would not recommend it. In a
normalized database things should not be duplicated and that goes for
geometries. I would recommend that you put your geometries in a separate
table. Table A and Table B would join to the geometries table.

Rich


On Thu, Jul 18, 2013 at 9:15 AM, Melin Maxence <maxencemelin at yahoo.fr>wrote:

> Hi,
>
> Do you know if it is possible to have in the_geom field of one record in a
> table A, a link (query, hypertext, something else...) to the_geom field of
> another record in a different table (table B), so that when the geom is
> modified in the record of the table A, it is automatically modified in the
> related record of the table B ?
>
> Thanks for your answers !
>
> Max
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>


-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130719/2035c858/attachment.html>


More information about the postgis-users mailing list