<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>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</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2> DATA "the_geom
FROM parcels"</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>When testing this
same database on 8.3 using the same Mapserver postgis drivers with the above, I
am getting this error</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008>MapServer error: Error in
msPOSTGISLayerRetrievePGVersion(): Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13)).</SPAN></DIV>
<DIV><SPAN class=067423112-08022008>Regular table layers work fine
regardless.<BR></DIV></SPAN>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>But rewriting the
Data part to </FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>DATA "the_geom FROM
parcels USING UNIQUE gid USING SRID=2249"</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>resolves the
issue. Last I had tested it was on 8.3RC2 so I thought it was the RC that
was throwing it off.</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>-- This might be
only an issue with PostgreSQL compiled under VC++ - below are the versions
returned by both.</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2><STRONG>"PostgreSQL
8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2><STRONG>"PostgreSQL
8.3.0, compiled by Visual C++ build 1400"</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>So it seems the old
version always had an <STRONG>on </STRONG>in the version() return and
the new Stack Builder version is missing the <STRONG>on
part.</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><STRONG><FONT face=Arial
size=2></FONT></STRONG></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>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
</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial size=2>Mapscript:
($Revision: 6872 $ $Date: 2007-09-10 10:45:30 -0400 (Mon, 10 Sep 2007) $)
</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><STRONG><FONT face=Arial
size=2></FONT></STRONG></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2>Regina</FONT></SPAN></DIV>
<DIV><SPAN class=067423112-08022008><STRONG><FONT face=Arial
size=2></FONT></STRONG></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT> </DIV></SPAN>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=067423112-08022008><FONT face=Arial
size=2></FONT></SPAN> </DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>