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'
