From: Tom Lane <tgl@sss.pgh.pa.us>
To: Paulo Scardine <paulos@cimed.ind.br>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-odbc@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [HACKERS] Killing the backend to cancel a long waiting query
Date: Thu, 18 Sep 2003 15:08:48 -0400
Message-ID: <1469.1063912128@sss.pgh.pa.us> (raw)
In-Reply-To: <007701c37e0f$4fc1b550$6101a8c0@Paulo>
References: <Pine.LNX.4.33.0309161858470.30978-100000@leary.csoft.net>
<2054.1063808792@sss.pgh.pa.us>
<3F69A6DE.1050002@bigfoot.com>
<007701c37e0f$4fc1b550$6101a8c0@Paulo>
"Paulo Scardine" <paulos@cimed.ind.br> writes:
> So I hacked a small pggetpid and pgkillpid C functions, and now I can learn
> the backend's PID, start the query in a new thread, and kill the backend
> using another connection if I want.
I trust when you say "kill", you really mean "send SIGINT" ...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, paulos@cimed.ind.br, pgsql-hackers@postgresql.org, pgsql-odbc@postgresql.org
Subject: Re: [HACKERS] Killing the backend to cancel a long waiting query
In-Reply-To: <1469.1063912128@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox