Re: uninterruptable loop: concurrent delete in progress within table - Mailing list pgsql-bugs

From Sandro Santilli
Subject Re: uninterruptable loop: concurrent delete in progress within table
Date
Msg-id 20140605055856.GA5221@localhost
Whole thread Raw
In response to Re: uninterruptable loop: concurrent delete in progress within table  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: uninterruptable loop: concurrent delete in progress within table
Re: uninterruptable loop: concurrent delete in progress within table
List pgsql-bugs
On Thu, Jun 05, 2014 at 01:04:51AM +0200, Andres Freund wrote:
> Hi Sandro,
>
> On 2014-05-30 16:31:50 +0200, Sandro Santilli wrote:
> > The attached script shows a plpgsql function that enters
> > an infinite loop which is not interrupted by statement_timeout.
>
> Pushed a fix. Thanks for the report!

Thanks, will test asap.

BTW, I noticed the commit contained no testcase, would it be safer
to include one ? The smallest test I got to (not requiring PostGIS)
is here: http://strk.keybit.net/tmp/crash.sql


--strk;

pgsql-bugs by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: [HACKERS] BUG #9652: inet types don't support min/max
Next
From: Sandro Santilli
Date:
Subject: Re: uninterruptable loop: concurrent delete in progress within table