Re: BUG #7881: SQL function failures in long-lived calling contexts - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7881: SQL function failures in long-lived calling contexts
Date
Msg-id 13304.1362349082@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #7881: SQL function failures in long-lived calling contexts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I wrote:
> Or we could add fields recording the current transaction/subtransaction
> IDs, then throw away and regenerate the function cache entry if that
> subxact is no longer active.  This would be a bit more invasive/riskier
> than throwing a "not supported" error, but it would preserve the
> functionality.

The attached patch seems fairly reasonable for this.

            regards, tom lane


Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #7881: SQL function failures in long-lived calling contexts
Next
From: Louis-Arnaud Iscla
Date:
Subject: "Password" issues -- bug??