[postgis-users] Stupid Database Mistake?

[Obe, Regina]

Would there ever be a situation where geometry_columns table is created
before spatial_ref_sys? 

 I recall the older versions of postgres had an issue with loading
tables out of sequence in a dump file, but I think the issue was
resolved in the 8+ releases.  I guess that would be the only potential
show stopper I could see. 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Wednesday, March 07, 2007 4:45 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Stupid Database Mistake?

I just recognized that our definition of GEOMETRY_COLUMNS does not 
declare that SRID is a foreign key linked to SRID in SPATIAL_REF_SYS. 
That seems like a potentially dangerous oversight. Does anyone see a 
problem if that restriction was *added*?

Paul

-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.