Postgres Pro
Downloads
Home   >   mailing lists

Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP
Date
Msg-id 869dee44-007f-a50e-c673-bda96ea31b12@gmx.net
Whole thread Raw
In response to Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP  (gogala.mladen@gmail.com)
Responses Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP
List pgsql-general
Tree view 
gogala.mladen@gmail.com schrieb am 19.10.2022 um 01:46:
> Amazon, lead by Kevin Closson, the guy who has famously designed
> Oracle Exadata among other things, even came up with the recipe how
> to migrate it to Postgres:
>
> https://aws.amazon.com/blogs/database/migrating-oracle-autonomous-transactions-to-postgresql/


The workaround to use dblink to simulate autonomous transactions is nothing new,
and has been floating around for quite a while.

Here is a blog post from 2012 (6 years before the Amazon recipe was published)

https://raghavt.blog/autonomous-transaction-in-postgresql-9-1/

and another one from 2016

https://blog.dalibo.com/2016/09/08/Pragma_Autonoumous_transactions.html

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Postgres 15 upgrades and template1 public schema
Next
From: Adrian Klaver
Date:
Subject: Re: Column value derived from generated column in INSERT?