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

[Paul Ramsey]

Badabing. OK, the win32 libpq for pgsql 7.1 has an 8K limit for some
reason (and the unix version does not, go figure) and this causes large
features to get messed up on the way to mapserver. Anyhow, if you get
the pgsql 7.2 version of libpq for win32, you will find the 8k
limitation is removed (!). Also, the 7.2 libpq can interoperate with a
7.1 backend, so there will not be a version problem.

Paul

Sean Gillies wrote:
> 
> 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'),oid::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
> >
> >
> >

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Access Your PC from Anywhere
Check Email & Transfer files - Free Download
http://us.click.yahoo.com/Z8IZpD/3XkDAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/