[postgis-users] Vacuum analyse ERROR: Operation on twoGEOMETRIESwith different SRIDs

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Sergey Karin
> Sent: 15 June 2005 11:29
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Vacuum analyse ERROR: Operation 
> on twoGEOMETRIESwith different SRIDs

(cut)

> strk, If my syggestion is interest, I think that table 
> containing mixed-SRID geometries shouldn't be considered 
> corrupted!

Hmmm, well they are not corrupted but they are meaningless in terms of a
spatial database ;)

Since you already have a srid integer column, I would just use that in your
application  instead, and set all your SRIDs to -1 for all geometries in the
start_point and boundary columns.


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk