PostGIS error on 4.8b2

[Howard Butler]

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'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20051210/748bf8ae/attachment.htm>