Re: Perl DBI::Pg - Stop button - Mailing list pgsql-general

From Richard Huxton
Subject Re: Perl DBI::Pg - Stop button
Date
Msg-id 200305070733.00052.dev@archonet.com
Whole thread Raw
In response to Re: Perl DBI::Pg - Stop button  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Perl DBI::Pg - Stop button  (Dennis Gearon <gearond@cvc.net>)
Re: Perl DBI::Pg - Stop button  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
On Wednesday 07 May 2003 3:55 am, Tom Lane wrote:
> Mr Mat psql-mail <psql-mail@freeuk.com> writes:
> > Whats the best way to terminate a query when the user presses the stop
> > button?
>
> Send a cancel request.
>
> I don't know whether the DBI/DBD stack supports that though :-(

I think the thrust of Matt's question was whether there is any way to know
when the user presses "stop" in their browser from the server end.
Unfortunately, since HTTP is a stateless protocol, the short answer is no.

This is of course simple if you have a java applet sitting on your page
connecting to your server - it can signal out of band.

[Not often I follow-up a post by Tom ;-]
--
  Richard Huxton


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: select offset by alphabetical reference
Next
From: Richard Huxton
Date:
Subject: Re: Cancelling a command.