query not aborted upon connection aborted?

query not aborted upon connection aborted?

am 28.06.2003 23:09:21 von Eric Koh

This is a multi-part message in MIME format.

------=_NextPart_000_0018_01C33DFC.99CDCC40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I'm using http 2.0.40 and postgresql 7.3.2 (redhat 9)

When my php script executes a long-running query and user hits the stop but=
ton, the query does not terminate and continues to run its full course. Is =
this the normal behaviour? Further calls from the same browser window using=
the same connection does not execute and are queued until the first one te=
rminates. This has led to max_connection reached errors.

My question is, is this the normal postgres/php behaviour, and if so, what =
is the best way to work around this?

Thanks!
------=_NextPart_000_0018_01C33DFC.99CDCC40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi,

 

I'm using =3D2>http=20
2.0.40 and
postgresql 7.3.2 (redhat=20
9)

 

When my php script executes a long-running=
query=20
and user hits
the stop button, the query=
does not=20
terminate and continues
to run its full =
course.=20
Is this the normal behaviour? Further calls from the same browser window us=
ing=20
the same connection does not execute and are queued until the first one=20
terminates. This has led to max_connection reached errors.

 

My question is, is this the normal postgre=
s/php=20
behaviour, and if so, what is the best way to work around this?

 

Thanks!


------=_NextPart_000_0018_01C33DFC.99CDCC40--