Re: Perl DBI::Pg - Stop button

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, psql-mail(at)freeuk(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Perl DBI::Pg - Stop button
Date: 2003-05-07 06:32:59
Message-ID: 200305070733.00052.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 07 May 2003 3:55 am, Tom Lane wrote:
> Mr Mat psql-mail <psql-mail(at)freeuk(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-05-07 06:48:35 Re: Cancelling a command.
Previous Message Oliver Elphick 2003-05-07 06:19:00 Re: select offset by alphabetical reference