Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux