[postgis-users] Stupid Database Mistake?

[Paul Ramsey]

Emily has pointed out that the loader defaults to -1 SRID, which 
wouldn't have a value necessarily.  We would have to figure out a 
reasonable noop record we could add to link for those items that have no 
SRID.

P

Obe, Regina wrote:
> 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