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

[pcreso at pcreso.com]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120423/73ded588/attachment.html>