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

Mark Cave-Ayland m.cave-ayland at webbased.co.uk
Tue Jun 1 03:09:42 PDT 2004


> -----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?


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.





More information about the postgis-users mailing list