MapServer & PostGIS won't work..

[Ken Lord]

I've never had any luck using the simple PostGIS DATA string: 
 DATA "the_geom from mytable"
 To make any PostGIS layer work, I've always had to use strings similar to 
the following:
 DATA "the_geom from (SELECT * from mytable) as foo using unique gid using 
SRID=2163"
 Give that a shot!
 Cheers,
Ken Lord
Vancouver BC

 On 6/3/05, Robert Campbell <rrc124 at gmail.com> wrote: 
> 
> I updated my line record's SRID to a valid one in the spatial_ref_sys
> table (I set it to 2163) and changed the STATUS to DEFAULT. I still
> get nothing. Is there anything else I can try? :-/
> 
> Thanks everyone..
> 
> 
> On 6/3/05, Mark Cave-Ayland <m.cave-ayland at webbased.co.uk> wrote:
> >
> > > -----Original Message-----
> > > From: UMN MapServer Users List
> > > [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of Robert Campbell
> > > Sent: 03 June 2005 05:55
> > > To: MAPSERVER-USERS at LISTS.UMN.EDU
> > > Subject: [UMN_MAPSERVER-USERS] MapServer & PostGIS won't work..
> > >
> > >
> > > I just installed Postgres 8.0 and PostGIS 1.0.1 Win32
> > > binaries. Both work; I have a nice demo table set up with
> > > geometry columns, queries work okay through pgAdmin III, etc.
> >
> > (cut)
> >
> > > Thanks everyone! Oh, and I was able to log in with psql using
> > > the two above CONNECTION string details (postgres & localhost).
> >
> >
> > Hi Robert,
> >
> > Try setting STATUS to DEFAULT for the PostGIS layer (DEFAULT and ON have
> > different meanings than you may expect...)
> >
> >
> > Kind regards,
> >
> > Mark.
> >
> > ------------------------
> > WebBased Ltd
> > South West Technology Centre
> > Tamar Science Park
> > Plymouth
> > PL6 8BT
> >
> > T: +44 (0)1752 797131
> > F: +44 (0)1752 791023
> > W: http://www.webbased.co.uk
> >
> >
> >
> 
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050603/01f7175d/attachment.htm>