Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function

Jeff Ross <jross@openvistas.net>

From: Jeff Ross <jross@openvistas.net>
To: pgsql-general@lists.postgresql.org
Date: 2024-03-20T22:55:00Z
Lists: pgsql-general
On 3/20/24 16:50, Tom Lane wrote:
> Jeff Ross <jross@openvistas.net> writes:
>> I then get this error:
>> NOTICE:  update cargotel_common.copy_orders_to_dev set copy_completed =
>> 't', copy_completed_timestamp = clock_timestamp() where id = 21
>> ERROR:  cannot commit while a portal is pinned
> Would you mind supplying a self-contained example that triggers this?
>
> 			regards, tom lane
>
>
I'll see if I can up with something.

Thanks for the reply!

Jeff