[postgis-users] Problems with Select by Polygon - pgsql75win

[Randy Page]

Zamil,

Great idea!  It worked like a charm, and gave me the following (corrected)
SQL:

SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
tracts_c WHERE the_geom && setSRID('BOX3D(-78.83 35.87,-78.7 35.96)'::BOX3D,
find_srid('','tracts_c','the_geom') )

This sql executes in less than a second and returns the expected results.
So, why is mapserver hanging on this?

Thanks,

Randy

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Zamil
Murji
Sent: Tuesday, August 03, 2004 1:50 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Problems with Select by Polygon - pgsql75win

Why don't you try purposely making a mistake in your data statement. I like
to spell my table name wrong. Mapserv will die with an error message that
gives you the sql statement it was trying to execute. Change all the
mistakes
back to the proper table name and run that select statement in postgres.
Do a query analyze on that...

Hope that helps.
Zamil

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Randy
Page
Sent: Tuesday, August 03, 2004 11:45 AM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] Problems with Select by Polygon -
pgsql75win


David,

I can't seem to get to that point due to the timeout.  I even bumped the
timeout up to 20,000 seconds with no change.   I have been watching the disk
& cpu usage on the PostGIS server, and it's doing absolutely nothing during
the time the request is taking place.

Randy

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of David
Blasby
Sent: Tuesday, August 03, 2004 1:03 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problems with Select by Polygon - pgsql75win

it should be writing it back to your web browser.  Do a "view page
source...".

dave

On Tue, 3 Aug 2004 11:57:55 -0400, Randy Page <randy.page at terraverge.com>
wrote:
> Dave,
> 
> Thanks for the advice.   I tried this, but I am not sure where MS is
writing
> the debug info (I am using IIS.)   I looked in the IIS logs, but didn't
see
> anything but the basic request.
>
_______________________________________________
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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users