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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] [EMAIL PROTECTED]
