[postgis-users] Problem with 'using unique' in Mapserver DATA statement

[Debbie Pagurek]

I seem to have a problem using UNIQUE indexes in my MapServer Data 
statements.

This doesn't work:
DATA "geom from (select geom, oid,gid, pearseda from pda42304) as foo 
using unique gid using SRID=42304"

But this does:
DATA "geom from (select geom, oid,gid, pearseda from pda42304) as foo 
using SRID=42304"

The error returns "ERROR:  syntax error at or near "using" at 
character 161". I don't see anything wrong!

I have the following indexes defined on my layer: idx_pda42304_oid
CREATE INDEX idx_pda42304_oid ON pda42304 USING btree (oid)

idx_pda42304_pearseda
CREATE INDEX idx_pda42304_pearseda ON pda42304 USING btree (pearseda)

pda42304_gidx
CREATE INDEX pda42304_gidx ON pda42304 USING gist (geom)
pda42304_pkey
CREATE UNIQUE INDEX pda42304_pkey ON pda42304 USING btree (gid)

Any suggestions? I hope I've just missed something obvious. Also, I used 
to have similar statements working,even ones that transformed 
coordinates, so I can't figure out what has changed.

D. Pagurek
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com