Quick Links

how to cancel a query ?

Lists:	pgsql-admin

From:	Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>
To:	pgsql-admin(at)postgresql(dot)org
Subject:	how to cancel a query ?
Date:	2002-12-04 14:47:25
Message-ID:	200212041547.26013.a.schmitz@cityweb.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-admin

Hello,

ist there any way to cancel a user query as dba ?

regards

-andreas

--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a(dot)schmitz(at)cityweb(dot)de

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	a(dot)schmitz(at)cityweb(dot)de
Cc:	pgsql-admin(at)postgresql(dot)org
Subject:	Re: how to cancel a query ?
Date:	2002-12-04 16:47:21
Message-ID:	14847.1039020441@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-admin

Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> writes:
> ist there any way to cancel a user query as dba ?

Send a SIGINT to the backend process running that query, eg

kill -INT <pid>

This has the same effect as a user-requested cancel (eg ^C in psql).

regards, tom lane

From:	Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:	a(dot)schmitz(at)cityweb(dot)de, pgsql-admin(at)postgresql(dot)org
Subject:	Re: how to cancel a query ?
Date:	2002-12-04 18:27:07
Message-ID:	200212041827.gB4IR7S07403@candle.pha.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-admin

Tom Lane wrote:
> Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> writes:
> > ist there any way to cancel a user query as dba ?
>
> Send a SIGINT to the backend process running that query, eg
>
> kill -INT <pid>
>
> This has the same effect as a user-requested cancel (eg ^C in psql).

And finally documented in 7.3. ;-)

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

From:	Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgman(at)candle(dot)pha(dot)pa(dot)us
Cc:	pgsql-admin(at)postgresql(dot)org
Subject:	Re: how to cancel a query ?
Date:	2002-12-05 12:50:44
Message-ID:	200212051350.44846.a.schmitz@cityweb.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-admin

On Wednesday 04 December 2002 17:47, Tom Lane wrote:
> Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> writes:
> > ist there any way to cancel a user query as dba ?
>
> Send a SIGINT to the backend process running that query, eg
>
> kill -INT <pid>
>
> This has the same effect as a user-requested cancel (eg ^C in psql).
>

What about an implementation into the command structure ?

regards

-andreas

--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a(dot)schmitz(at)cityweb(dot)de

From:	Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To:	a(dot)schmitz(at)cityweb(dot)de
Cc:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject:	Re: how to cancel a query ?
Date:	2002-12-05 19:19:21
Message-ID:	200212051919.gB5JJL223182@candle.pha.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-admin

Andreas Schmitz wrote:
> On Wednesday 04 December 2002 17:47, Tom Lane wrote:
> > Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> writes:
> > > ist there any way to cancel a user query as dba ?
> >
> > Send a SIGINT to the backend process running that query, eg
> >
> > kill -INT <pid>
> >
> > This has the same effect as a user-requested cancel (eg ^C in psql).
> >
>
> What about an implementation into the command structure ?

Libpq has:

PQrequestCancel()

Where else did you want it?