[postgis-users] MapServer config issues

[Kralidis,Tom [Burlington]]

You're not? :)

It seems that I didn't ref the oid col correctly, and I had issues with
auto-oid generation in the db (turned off by default).  Fixed in
$PGSQL_HOME/data/postgresql.conf, then redid the tables and all works.

Thanks much

..Tom


> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Paul Ramsey
> Sent: Tuesday, February 21, 2006 3:31 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] MapServer config issues
> 
> 
> 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
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>