[mapserver-users] PostGIS and Temporary Tables

[Dave Blasby]

This is probably a problem because there is no true OID in the temporary
table you're using.

Use the latest CVS version of mapserver, and :

DATA "geometry from (select * from temporary_table) as foo using unique
<unique> using SRID=<srid>"

Where <unique> is the name of a column in temporary_table that uniquely
identifies a row, and <srid> is the SRID of your data.

Using the CVS version will also give you more error information if this
doesnt work.

dave
ps. 
If you do a "select * from temporary_table limit 5" you'll see
geometries described like 'SRID=#;<geometry data>'.  This '#' is the
SRID of your data.