[mapserver-users] msPOSTGISLayerGetShape(): Error

[Obe, Regina]

Actually I remember yeh back there was an automatic boolean cast put in
the lwpostgis.sql.  I think it was later removed because it was felt
doing such things in Postgis was stepping out of bounds since that cast
really has nothing to do with postgis and there is no internal
dependency on it.

Here is a thread about the issue
http://postgis.refractions.net/pipermail/postgis-users/2007-October/0174
52.html

I suspect maybe its because you are running a newer version of PostGIS
(that I think has the cast removed where the cast was removed) not
PostgreSQL that you are experiencing it.

Hope that Helps,
Regina
 

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Paul Moen
Sent: Thursday, February 28, 2008 4:08 PM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] msPOSTGISLayerGetShape(): Error

I just upgraded to postgres 8.2.6

And postgis 1.3.2("POSTGIS="1.3.2" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel.
4.6.0, 21 Dec 2007" USE_STATS") and I get the following error.

PHP Fatal error:  [MapServer Error]: msPOSTGISLayerGetShape(): Error
executing POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor2 BINARY
CURSOR FOR SELECT 
"site_id"::text,"location"::text,"longitude"::text,"latitude"::text,"cou
nty"
::text,"status"::text,"arb_siteno"::text,"last_name"::text,"first_name":
:tex
t,"add1"::text,"add2"::text,"city"::text,"state"::text,"zip"::text,"phon
e"::
text,"remarks"::text,"password"::text,"email"::text,"online_reporting"::
text
,"x_coord"::text,"y_coord"::text,asbinary(force_collection(force_2d(geom
)),'
NDR') from station WHERE site_id = 4243
-ERROR:  cannot cast type boolean to text, referer: http://10.8.54.31/
: ..."::text,"latitude"::text,"county"::text,"status"::text,"arb_...,
                                                       ^,

My table in postgresql is

CREATE TABLE station
(

    site_id integer NOT NULL DEFAULT 0,
    "location" character varying(14) NOT NULL DEFAULT '',
    longitude double precision NOT NULL DEFAULT 0,
    latitude double precision NOT NULL DEFAULT 0,
    county character varying(30) NOT NULL DEFAULT '',
    status boolean NOT NULL DEFAULT false,
    arb_siteno character varying(5) NOT NULL DEFAULT '',
    last_name character varying(35) NOT NULL DEFAULT '',
    first_name character varying(20) NOT NULL DEFAULT '',
    add1 character varying(21) NOT NULL DEFAULT '',

    add2 character varying(21) NOT NULL DEFAULT '',
    city character varying(20) NOT NULL DEFAULT '',
    state character varying(2) NOT NULL DEFAULT '',
    zip character varying(9) NOT NULL DEFAULT '',
    phone character varying(10) NOT NULL DEFAULT '',
    remarks text NOT NULL DEFAULT '',
    "password" character varying(20) NOT NULL DEFAULT '',
    email character varying(80) NOT NULL DEFAULT '',
    online_reporting boolean NOT NULL DEFAULT false,
    x_coord integer NOT NULL DEFAULT 0,
    y_coord integer NOT NULL DEFAULT 0,
    geom geometry,
)

My mapscript version is

MapServer Version    MapServer version 5.0.2 OUTPUT=GIF OUTPUT=PNG
OUTPUT=JPEG OUTPUT=WBMP 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=GEOS INPUT=EPPL7
INPUT=POSTGIS
INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
PHP MapScript Version    ($Revision: 7251 $ $Date: 2008-01-08 09:04:53
-0800
(Tue, 08 Jan 2008) $)

All running on Mac OS 10.5.

msPOSTGISLayerGetShape() tries to cast the status column to text, did it
always do that?  

PostgreSQL 8.3 will have a type cast from boolean to text.  But none of
the
earlier versions were supposed to.

I can run the sql 
SELECT status::text from station
with no errors in PostgreSQL 8.2.4 but not in 8.2.5 or 8.2.6, which
leads me
to believe that there was in a cast from boolean to text in 8.2.4.

I never added a custom cast to do this before, so I am wondering if the
only
thing that changed is PostgreSQL?  Can anyone confirm that there was a
cast
for boolean to text in PostgreSQL 8.2.4?

Thanks,

Paul

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-----------------------------------------
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.