Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Ross <jross@openvistas.net>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2024-03-20T22:50:36Z
Lists: pgsql-general 
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