[postgis-users] viewer postgis with my mapfile

[Paul Ramsey]

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 <Quentin.Page at ensg.eu> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>