Re: [HACKERS] Terminating a backend - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: [HACKERS] Terminating a backend
Date
Msg-id 20080413200451.GC21979@alvh.no-ip.org
Whole thread Raw
In response to Re: [HACKERS] Terminating a backend  (Bruce Momjian <bruce@momjian.us>)
List pgsql-patches
Bruce Momjian wrote:

> I have a idea --- to have pg_terminate_backend() set a PGPROC boolean
> and then send a query cancel signal to the backend --- the backend can
> then check the boolean and exit if required.  I will work on a new
> version of this patch tomorrow/Monday.

That's fine, even if it fails on 0.1% of the cases, but you can't use
SIGTERM to implement that because it already has a different meaning.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: printTable API (was: Show INHERIT in \du)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Remove lossy-operator RECHECK flag?