Thanks Regina and Colin for the replies. I was hoping that I wasn't imagining things. I will just add the cast until I install PosgreSQL 8.3.
Paul On 2/29/08 7:54 AM, "Obe, Regina" <[EMAIL PROTECTED]> wrote: > 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: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Paul Moen > > Sent: Thursday, February 28, 2008 4:08 PM > > To: [email protected] > > 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 > > [email protected] > > 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. > > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
