From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Jeff Ross <jross(at)openvistas(dot)net>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function |
Date: | 2024-03-20 22:56:17 |
Message-ID: | 37154728-4700-45b7-9261-72400c80b12b@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 3/20/24 15:52, Jeff Ross wrote:
> On 3/20/24 16:25, Adrian Klaver wrote:
>
>> On 3/20/24 15:18, Jeff Ross wrote:
>>> Greetings!
>>>
>>> I built a trigger fired process that copies an "order" from our
>>> production database to our dev database. An order, in this case, is
>>> an initial row from a table and all of the rows in all of the tables
>>> in that database/schema that are needed to satisfy all of the foreign
>>> key constraints for the original insert. Through a web page, one of
>>> our folks can select a schema and an order id to copy. That
>>> information is then inserted into a table. A trigger attached to
>>> that table takes care of copying the necessary rows using a function
>>> that uses both plython3u and psycopg2. I can supply the source code
>>> if that will help.
>>
>> I think that will help, especially the interaction between psycopg2
>> and plpython3u.
>>
> As requested:
>
> https://openvistas.net/copy_orders_to_dev.html
Haven't had a chance to go through this yet. I'm going to say though
that Tom Lane is looking for a shorter generic case that anyone could
run on their system.
>
> Jeff
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-03-20 23:04:18 | Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function |
Previous Message | Jeff Ross | 2024-03-20 22:55:00 | Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function |