[mapserver-users] PostGIS and Temporary Tables

[Homme Zwaagstra]

Thanks for the tip. It looks like an upgrade to 3.6 is the way
forward, as I also tried Tyler's suggestion of updating the
geometry_columns table with the relevant metadata with no luck. Whilst
on the topic of upgrades, is there an ETA for 3.7? I might just wait :)

> 
> 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.