[postgis-users] viewer postgis with my mapfile

Quentin Page Quentin.Page at ensg.eu
Fri Feb 27 05:47:41 PST 2009


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




More information about the postgis-users mailing list