Postgresql: How to access data of a transaction with another connection

Question

Goodmorning,

I use Postgresql for my database engine and some operations use transactions to be sure that everything goes fine. Sometimes I need to test some specific datas at "that poin" of my application but these operations often make al lot changes in the database and it's not easy to reproduce "all the changes made inside the transaction" with another connection (like using a PgAdmin query tool) outside the transaction to test the single aspect that i need.

One way to test the specific data, is to load the data into a variable, and then debug-it, but i was searching for a more "wide solution".

So that's the question: Is there a way to access the data of a specific connection (which is in transaction) with another connection/query_tool?

Thanks, Attilio

Not possible, Postgres does not not allow dirty reads

user330315
– user330315

2020-02-17 11:52:02 +00:00
Commented Feb 17, 2020 at 11:52 — user330315
– user330315, Commented Feb 17, 2020 at 11:52

AttilioDM · Accepted Answer · 2020-07-07 14:52:50Z

3

In postgresql (actually) there's no way to do it, full stop.

answered Jul 7, 2020 at 14:52

AttilioDM

817 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql: How to access data of a transaction with another connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related