Found the Problem (Re: [mapserver-users] Is PostGIS broken in latest nightly build on Win32?)

[Pericles S. Nacionales]

Sean,

You'll probably have better luck getting answers to your question using
the PostGIS support...  http://postgis.refractions.net/support.php.
They have an FAQ and a web-based discussion group.

Good luck!
Perry

-----Original Message-----
From: owner-mapserver-users at lists [mailto:owner-mapserver-users at lists]
On Behalf Of Sean Gillies
Sent: Tuesday, March 12, 2002 12:44 PM
Cc: mapserver-users at lists
Subject: Found the Problem (Re: [mapserver-users] Is PostGIS broken in
latest nightly build on Win32?)

My features are too large (in bytes). When I query with
'astext(envelope(the_geom))', the bounding boxes of the
features are returned properly.

Are geometries limited to 8k?  Will this limit be lifted
in postgresql 7.2?

Sean

Sean Gillies wrote:

> Greetings,
> 
> Am having sucess using PostGIS (very recent CVS build) as a data
source
> with mapserver built on Linux but am unable to use this same data
source
> with the most recent ms351_nightly w/postgis.
> 
> I am seeing this error:
> 
> msPOSTGISLayerWhichShapes(): Query error. Error executing POSTGIS SQL 
> statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT 
>
State_abbr::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),oi
d::text 
> from dtlst WHERE the_geom && setSRID('BOX3D(-126 22.2637931034483,-65 
> 51.7362068965517)'::BOX3D, find_srid('','dtlst','the_geom') )
> 
> The win32 binary works with shapefile data, but not with a PostGIS
data 
> source which works with our Linux mapserver.  The PostgreSQL server
> is on Linux and we reliably access it from many other windows
> applications.
> 
> The software versions are:
> PostgreSQL 7.1.2
> PostGIS 0.7-ish (from CVS on March 5)
> Mapserver win32 binary w/ postgis from March 11
> 
> Looking forward to hearing any solutions or suggestions,
> 
> Sean
> 
> 
>