[postgis-users] PostGIS-PostgreSQL

[Chris Hermansen]

This is a part of good database design. Street name, which can be changed, is only stored in one location.

This is part of "normalization".  This practice relates to any / all databases 
------Original Message------
From: Nenad Milasinovic
Sender: postgis-users-bounces at postgis.refractions.net
To: postgis-users at postgis.refractions.net
ReplyTo: PostGIS Users Discussion
Subject: [postgis-users] PostGIS-PostgreSQL
Sent: Jul 13, 2009 06:18

Hello,

I have some questions relating to PostGIS and PostgreSQL.
I am interested how GEO-data from PostGIS are connected to data in 
PostgreSQL.
Say that we have vector layer of all city streets in PostGIS table, with 
some street attributes (e.g. street name).
Say also that we have all data about locations in PostgreSQL table. That 
data contains information about location street also.
What i want to accomplish is that when user change street name is 
PostGIS table, that street name should automatically be changed in
all locations which belongs to that street. I am interested is there any 
connection between tables in PostGIS and PostgreSQL
that could automatize this process, or i need to update all locations 
with new street data by myself.

Thanks.




-- 
Nenad Milasinovic
Software Development and Testing

---

"ZESIUM mobile" d.o.o.
Valentina Vodnika 8/9
21000 Novi Sad
Serbia
Tel: +381 (0)21 472 15 48
Fax: +381 (0)21 472 15 49
Mob: +381 (0)61 231 41 20
E-mail: nenad.milasinovic at zesium.com

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Chris Hermansen        chris.hermansen at timberline.ca
tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.840.4625
Timberline Natural Resource Group · www.timberline.ca
401 · 958 West 8th Avenue  · Vancouver BC · Canada · V5Z 1E5