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 > (0102000020FF7F000007000000DAC9D95234D52941812D342D81653C416B217C3D35D52941C5E15F5D7C653C41202863FD37D5294192A8406876653C41B27F05E838D5294107C15C5073653C41286D500D3AD52941357BEF8D6C653C41D52E4ABD3AD52941E7D778D366653C4182F0436D3BD5294154ABA7AB61653C41)),' > NDR '), ogc_fid:: text from path as foo > 0102000020FF7F000007000000DAC9D95234D52941812D342D81653C416B217C3D35D52941C5E15F5D7C653C41202863FD37D5294192A8406876653C41B27F05E838D5294107C15C5073653C41286D500D3AD52941357BEF8D6C653C41D52E4ABD3AD52941E7D778D366653C4182F0436D3BD5294154ABA7AB61653C41 > WHERE setSRID & & ( 'BOX3D (640046.134570766 857916,2074083.86542923 > 1856414)':: BOX3D, 27582) 'Postgresql reports the error as' ERROR: syntax > error at or near "in > FF7F000007000000DAC9D95234D52941812D342D81653C416B217C3D35D52941C5E15F5D7C653C41202863FD37D5294192A8406876653C41B27F05E838D5294107C15C5073653 > .... > 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
