PostGIS error on 4.8b2

[Paul Ramsey]

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'