gogala.mladen@xxxxxxxxx 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
