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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function
Дата
Msg-id a27826a2-9f22-4a5c-a0f2-cfe5dbc156c4@aklaver.com
обсуждение исходный текст
Ответ на After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function  (Jeff Ross <jross@openvistas.net>)
Список psycopg
On 3/21/24 09:06, Jeff Ross wrote:
> Greetings!
> 
> I posted a version of this to the pgsql-general mailing list yesterday.  
> Since then I've narrowed down the error to this line:
> 
> prod_database_connection.commit()
> 
> so I believe this is psycopg2 related.

Does it work outside of plpython3u?

> 
> This is on CentOS 7 and I'm using python3-psycopg2.x86_64 2.8.6-1.rhel7 
> installed from yum.

psycopg2 is up to 2.9.9. You are missing ~3 years of fixes.

> 
> makes me wonder if this error is specific to plpython3?

Hard to say as the other bug report you linked to seemed to refer to 
plpythonu.


> Jeff
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




В списке psycopg по дате отправления:

Предыдущее
От: Jeff Ross
Дата:
Сообщение: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function
Следующее
От: Aryeh Leib Taurog
Дата:
Сообщение: [MASSMAIL]pgcopy 1.6.0 release announcement