[postgis-users] MapServer config issues

[Paul Ramsey]

Can't *see* anything, but the I am not a SQL parser :) Have you tried  
putting the bits in () directly into the psql commandline?  If that  
works, have mapserver or pgsql log the actual SQL statement  
mappostgis is generating and try that.

P

On Feb 21, 2006, at 9:36 AM, Kralidis,Tom [Burlington] wrote:

>
> Hi,
>
> I'm trying to publish a OGC:WMS/OGC:WFS resource via MapServer.
>
> In my mapfile, the DATA directive is defined as follows:
>
> DATA "the_geom from (select hydromet_stations.stnid as
> stnid,hydromet_stations.the_geom as the_geom,
> hydromet_latest_water_levels.obsdate as graphurl from
> hydromet_latest_water_levels inner join hydromet_stations on
> hydromet_stations.stnid = hydromet_latest_water_levels.stnid) as t  
> using
> unique hydromet_latest_water_levels.id"
>
> When I attempt to visualize via an OGC:WMS client, I get the following
> exception:
>
> Postgresql reports the error as 'ERROR:  missing FROM-clause entry
> for table "hydromet_latest_water_levels"
> '<br><br>
>
> Can anyone see anything wrong with my DATA statement SQL?
>
> Thanks
>
> ..Tom
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users