Re: pg_cancel_backend() does not work with buzz queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Richard Huxton <dev(at)archonet(dot)com>, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_cancel_backend() does not work with buzz queries
Date: 2007-10-03 14:20:49
Message-ID: 15887.1191421249@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-ru-general

Magnus Hagander <magnus(at)hagander(dot)net> writes:
> Does pl/python listen to SIGINT during execution of functions? If not,
> that'd be an explanation - if it's stuck inside a pl/python function...
> AFAIK, pl/pgsql does listen for SIGINT during execution, but I don't nkow
> abuot plpython.

It does not, unless the function contains SPI calls that'll return
control into PG code.

Short answer: don't write infinite loops in plpython.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2007-10-03 15:10:28 Re: Tsearch2 Dutch snowball stemmer in PG8.1
Previous Message Tom Lane 2007-10-03 14:07:25 Re: PITR Recovery and out-of-sync indexes

Browse pgsql-ru-general by date

  From Date Subject
Next Message Erik Jones 2007-10-03 15:13:26 Re: pg_cancel_backend() does not work with buzz queries
Previous Message Alvaro Herrera 2007-10-03 12:12:36 Re: pg_cancel_backend() does not work with buzz queries