[postgis-users] PostgreSQL 8.3 and UMN Mapserver Issue

[Obe, Regina]

Sorry for the cross-post, but I wasn't sure who's problem it is.  This
is not a major issue and may already be fixed but could potentially
affect other software besides Mapserver, but in PostgreSQL 8.2 I had a
view that I manually registered in the geometry_columns table.
Registering it in the geometry_columns table allowed me to do this
 
 DATA "the_geom FROM parcels"
 
 
When testing this same database on 8.3 using the same Mapserver postgis
drivers with the above, I am getting this error
MapServer error: Error in msPOSTGISLayerRetrievePGVersion(): Error
executing POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select
substring(version() from 12 for (position('on' in version()) - 13)).
Regular table layers work fine regardless.

But rewriting the Data part to 
DATA "the_geom FROM parcels USING UNIQUE gid USING SRID=2249"
 
resolves the issue.  Last I had tested it was on 8.3RC2 so I thought it
was the RC that was throwing it off.
 
-- This might be only an issue with PostgreSQL compiled under VC++ -
below are the versions returned by both.
 
"PostgreSQL 8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"
 
"PostgreSQL 8.3.0, compiled by Visual C++ build 1400"
 
So it seems the old version always had an on in the version() return
and the new Stack Builder version is missing the on part.
 
I am using MapServer version 5.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG
OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG
SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER
SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS
INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE 
Mapscript: ($Revision: 6872 $ $Date: 2007-09-10 10:45:30 -0400 (Mon, 10
Sep 2007) $) 
 
 
Thanks,
Regina
 
 
 
 
 
 
 
 


-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080208/6ca35ad2/attachment.html>