Quentin, As Paul said seeing the map file would help to diagnose.
It would also help if we new the version of PostGIS/PostgreSQL you are running which you can get from SELECT postgis_full_version(); SELECT version(); And which platforms (Linux/Windows etc. you are running mapserver on. Version of mapserver -- the postgis_full_version will provide that info for the PostGIS/PostgreSQL side). Could be something really simple or really bizarre like a big endian little endian thing. Hope that helps, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Ramsey Sent: Friday, February 27, 2009 4:43 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] viewer postgis with my mapfile Without seeing your .map file I can't diagnose. PostGIS support in Mapserver works, so you probably have some odd configuration issue going on. P. On Fri, Feb 27, 2009 at 5:47 AM, Quentin Page <[email protected]> wrote: > > hello to all, > > I can not display data postgis > the error is: > [MapServer Error]: prepare_database (): Error executing PostGIS > DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR > FOR SELECT asbinary (force_collection (force_2d > (0102000020FF7F000007000000DAC9D95234D52941812D342D81653C416B217C3D35D52941C 5E15F5D7C653C41202863FD37D5294192A8406876653C41B27F05E838D5294107C15C5073653 C41286D500D3AD52941357BEF8D6C653C41D52E4ABD3AD52941E7D778D366653C4182F0436D3 BD5294154ABA7AB61653C41)),' > NDR '), ogc_fid:: text from path as foo > 0102000020FF7F000007000000DAC9D95234D52941812D342D81653C416B217C3D35D5 > 2941C5E15F5D7C653C41202863FD37D5294192A8406876653C41B27F05E838D5294107 > C15C5073653C41286D500D3AD52941357BEF8D6C653C41D52E4ABD3AD52941E7D778D3 > 66653C4182F0436D3BD5294154ABA7AB61653C41 > WHERE setSRID & & ( 'BOX3D (640046.134570766 857916,2074083.86542923 > 1856414)':: BOX3D, 27582) 'Postgresql reports the error as' ERROR: > syntax error at or near "in > FF7F000007000000DAC9D95234D52941812D342D81653C416B217C3D35D52941C5E15F > 5D7C653C41202863FD37D5294192A8406876653C41B27F05E838D5294107C15C507365 > 3 > .... > postgis was obtained with fwtools > no figure > how can we correct this error type. > > thanks a l > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
