[postgis-users] itemnquery limitation

[Paul Ramsey]

Have you confirmed that this is an issue specific to PostGIS, or does  
it happen with Shapefiles also?
P.

On Wednesday, August 6, 2003, at 09:34 AM, Tom Melhuish wrote:

> I’m performing an itemnquery and if I have 21 items in the list mapserv
> works fine. If I have 22 in the list mapserv hangs and I end up with a
> “premature end of script header” with no other error messages. Below  
> is the
> declare statement out of mapserv with 22 items listed, that doesn’t  
> work and
> 21 items that does work. I have about 50 nodeid and switched nodeid  
> around
> to confirm that I didn’t have a bad one in the list. A set of 21 works  
> fine
> and 22 or more hangs running mapserv. If I run this DECLARE statement  
> in
> postgresql it excecute "OK". If I run just the SELECT statement out of  
> this
> is runs fine and gives me the results I expect.
>
> Is their a limit in the C code that I can change to get around this in
> mapserv?
>
> 22 Items - fails
> -----------
>
> DECLARE mycursor BINARY CURSOR FOR SELECT
> nodeid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID:: 
> text
> from nodescomb_2003 WHERE (nodeid in
> ('413.0','430.0','431.0','432.0','433.0','434.0','436.1','450.0','451.0 
> ','45
> 2.0',
> '453.0','454.0','455.0','456.0','457.1','457.2','457.3','457.4','458.1' 
> ,'458
> .2','459.0','528.0')) and (the_geom && setSRID( 'BOX3D(2001272.875
> 643833.625,2099924.5
> 696954.5)'::BOX3D,find_srid('','nodescomb_2003','the_geom') ))
>
> 21 Items – works fine
> -----------
>
> DECLARE mycursor BINARY CURSOR FOR SELECT
> nodeid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID:: 
> text
> from nodescomb_2003 WHERE (nodeid in
> ('413.0','430.0','431.0','432.0','433.0','434.0','436.1','450.0','451.0 
> ','45
> 2.0',
> '453.0','454.0','455.0','456.0','457.1','457.2','457.3','457.4','458.1' 
> ,'458
> .2','459.0')) and (the_geom && setSRID( 'BOX3D(2001272.875
> 643833.625,2099924.5
> 696954.5)'::BOX3D,find_srid('','nodescomb_2003','the_geom') ))
>
> I’m running Mapserver 3.6.6, Postgres 7.3.2 & Postgis 0.7.4.
>
> -----------
> I really have the database set up to execute the following command  
> that will
> extract all of the nodeid (about 50) that are associated to a Base  
> type.
> After many days trying to troubleshoot the problem I rewrote the code  
> to run
> on individual items (nodeid). When I run this command I get the same  
> results
> as the delare statement with 22 or more items.
>
> DECLARE mycursor BINARY CURSOR FOR SELECT
> nodeid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID:: 
> text
> from nodescomb_2003 WHERE (Base10='428') and (the_geom && setSRID(
> 'BOX3D(2001272.875 643833.625,2099924.5
> 696954.5)'::BOX3D,find_srid('','nodescomb_2003','the_geom') ))
>
> Please let me know if you need more information to debug mu problem.
>
> Tom Melhuish
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
      Paul Ramsey
      Refractions Research
      Email: pramsey at refractions.net
      Phone: (250) 885-0632