PostGIS error on 4.8b2

[Ken Lord]

Thanks Howard,

That bug does seem to cover my problem,  I've added a post to the
report to confirm that it affects more than just postgresql 8.1 +
mapserver 4.8b2.

Paul, I'll try your suggestion on Monday. I had simplified my SQL
statement when trying to make it work, evidently I could have
simplified it more :)

Cheers,
Ken Lord
Vancouver BC



On 12/10/05, Howard Butler <hobu at iastate.edu> wrote:
> Is <http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1443>
> still relevant to this issue (issues with using *both* UNIQUE and SRID)?
>
> Howard
>
> At 12:33 PM -0800 12/10/05, Paul Ramsey wrote:
> Well, the error is unhelpful, and I am not sure why your data
> statement is failing. It is functionally equivalent to
>
> DATA "wkb_geometry FROM my_funky_table USING UNIQUE ogc_fid USING
> SRID=26910"
>
> So I don't know why you are nesting the SQL in this case.  Still it
> should work.  Turn on statement logging in postgresql and see if
> anything is making it to the database at all.
>
> P
>
> On 9-Dec-05, at 6:33 PM, Ken Lord wrote:
>
> > I haven't seen a response to this variation of the postgis / 4.8b2
> > issue yet, as posted by someone else.
> >
> > Has anyone figured out how to use PostgreSQL 8.0.3 / PostGIS 1.0.4
> > with MapServer 4.8b2?
> >
> > I have an OID column, I'm not using PostgreSQL 8.1.  But my DATA query
> > is rejected with an error near USING  ...
> >
> > If I use another unique column present in the table, it produces the
> > same error. This query did work with mapserver 4.6.
> >
> > Here's my DATA string:
> >
> > DATA "wkb_geometry FROM (SELECT * FROM my_funky_table) AS foo USING
> > UNIQUE ogc_fid USING SRID=26910"
> >
> > And here's the error:
> >
> > msDrawMap(): Image handling error. Failed to draw layer named
> > 'Funky_Table'
>
>


--
==============================
Ken Lord B.Sc., A.Dipl.T.H.
7488 Magnolia Terrace
Burnaby BC, V5E 4L1
604-777-2171
kenlord at gmail.com
klord at bgcengineering.com