[postgis-users] viewer postgis with my mapfile

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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 <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 
>
(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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users