<!doctype html public "-//W3C//DTD W3 HTML//EN">
<html><head><style type="text/css"><!--
blockquote, dl, ul, ol, li { padding-top: 0 ; padding-bottom: 0 }
--></style><title>Re: PostGIS error on 4.8b2</title></head><body>
<div>Is <<font face="Lucida Grande" size="-4"
color="#000000">http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1443</font
>> still relevant to this issue (issues with using *both* UNIQUE
and SRID)?</div>
<div><br></div>
<div>Howard</div>
<div><br></div>
<div>At 12:33 PM -0800 12/10/05, Paul Ramsey wrote:</div>
<blockquote type="cite" cite>Well, the error is unhelpful, and I am
not sure why your data <br>
statement is failing. It is functionally equivalent to<br>
<br>
DATA "wkb_geometry FROM my_funky_table USING UNIQUE ogc_fid
USING <br>
SRID=26910"<br>
<br>
So I don't know why you are nesting the SQL in this case. Still
it <br>
should work. Turn on statement logging in postgresql and see
if <br>
anything is making it to the database at all.<br>
<br>
P<br>
<br>
On 9-Dec-05, at 6:33 PM, Ken Lord wrote:<br>
<br>
> I haven't seen a response to this variation of the postgis /
4.8b2<br>
> issue yet, as posted by someone else.<br>
><br>
> Has anyone figured out how to use PostgreSQL 8.0.3 / PostGIS
1.0.4<br>
> with MapServer 4.8b2?<br>
><br>
> I have an OID column, I'm not using PostgreSQL 8.1. But my
DATA query<br>
> is rejected with an error near USING ...<br>
><br>
> If I use another unique column present in the table, it produces
the<br>
> same error. This query did work with mapserver 4.6.<br>
><br>
> Here's my DATA string:<br>
><br>
> DATA "wkb_geometry FROM (SELECT * FROM my_funky_table) AS
foo USING<br>
> UNIQUE ogc_fid USING SRID=26910"<br>
><br>
> And here's the error:<br>
><br>
> msDrawMap(): Image handling error. Failed to draw layer
named <br>
> 'Funky_Table'</blockquote>
<div><br></div>
</body>
</html>