[postgis-users] Incorrect results from queries specifying an SRID

[strk]

On Tue, Jun 01, 2004 at 11:09:42AM +0100, Mark Cave-Ayland wrote:
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net 
> > [mailto:postgis-users-bounces at postgis.refractions.net] On 
> > Behalf Of Paul Ramsey
> > Sent: 28 May 2004 21:10
> > To: PostGIS Users Discussion
> > Subject: Re: [postgis-users] Incorrect results from queries 
> > specifying an SRID
> > 
> > 
> > cp wrote:
> > > My expectation
> > > would be for postgis to automatically transform the 
> > coordinates to match 
> > > the SRID of the geometries stored in the table (4267) or at 
> > least to 
> > > give me an error.
> > 
> > You should be getting an error, that is the only noticable bug. SRID 
> > mismatches are supposed to raise errors (to prevent precisely the 
> > problem you demonstrate going quietly unnoticed).
> 
> Hmmm I think this is another symptom of not having RECHECK specified in
> the operator class - I thought that strk committed this change after we
> brought up the discussion earlier this year? It looks like it's only
> specified for PostgreSQL 7.1 at the moment.
> 
> [looks through the source...] It's definitely not in postgis_7*_end.sql
> for >= 7.2. strk, did this get lost somewhere in your changes for
> rebuilding postgis.sql?

postgis_7*.sql are obsolete code.
The new enabler script is postgis.sql.in
It contains RECHECK clauses for PG73,74,75 in CREATE OPERATOR CLASS

--strk;

> 
> 
> Cheers,
> 
> Mark.
> 
> ---
> 
> Mark Cave-Ayland
> Webbased Ltd.
> Tamar Science Park
> Derriford
> Plymouth
> PL6 8BX
> England
> 
> Tel: +44 (0)1752 764445
> Fax: +44 (0)1752 764446
> 
> 
> This email and any attachments are confidential to the intended
> recipient and may also be privileged. If you are not the intended
> recipient please delete it from your system and notify the sender. You
> should not copy it or use it for any purpose nor disclose or distribute
> its contents to any other person.
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users