[postgis-users] LWGEOM notice message - what does it mean?

[pcreso at pcreso.com]

Found the answer.... Thanks list :-)

http://postgis.17.n6.nabble.com/LWGEOM-gist-joinsel-called-with-incorrect-join-type-td3535176.html

--- On Tue, 4/24/12, pcreso at pcreso.com <pcreso at pcreso.com> wrote:

From: pcreso at pcreso.com <pcreso at pcreso.com>
Subject: [postgis-users] LWGEOM notice message - what does it mean?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Date: Tuesday, April 24, 2012, 7:30 AM

Hi,

Can anyone explain this message to me & whether it indicates anything I should be concerned about?

The stations table contains some 47,000 undersea sample sites. The other tables represent points of observations of various properties such as depth or temperature.

The query is to return an indicative value for each property for each station. The left outer join is required to ensure all station records are returned, whether or not there is a nearby value for any property.

The notice message only occurs when an outer join is specified, if it is not an outer join, then no message appears. The query appears to work fine, but I don't know the significance of the message, or what I have done to cause it. I figure that being a notice, rather than error or warning, it is not critical, but....


Any advice appreciated...

  Brent Wood




select s.ogc_fid,
       s.trip::integer as trip,
       s.station::varchar(20) as station,
       avg(d.depth)::decimal(6,2) as avg_depth,
       avg(t.botemp)::decimal(8,6) as avg_botemp,
       avg(a.aou)::decimal(8,6) as avg_aou
from allstations s
left outer join depths d on d.geom && buffer(s.wkb_geometry,125)
left outer join botemp t on t.geom && buffer(s.wkb_geometry,125)
left outer join aou a on a.geom && buffer(s.wkb_geometry,125)
where s.ogc_fid < 100
group by s.ogc_fid,
         s.trip,
         s.station
order by s.ogc_fid;
NOTICE:  LWGEOM_gist_joinsel called with incorrect join
 type
NOTICE:  LWGEOM_gist_joinsel called with incorrect join type
NOTICE:  LWGEOM_gist_joinsel called with incorrect join type


-----Inline Attachment Follows-----

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120423/2abbd723/attachment.html>