From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Remote troubleshooting session connection? |
Date: | 2014-04-05 00:32:01 |
Message-ID: | 1396657921150-5798823.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jim Garrison wrote
> Assuming I can pause the driving Java code between queries in a job, is
> there any way to connect from PGAdmin (or another tool) and view the state
> of tables in the in-progress transaction? If this is not currently
> possible, how difficult would it be to do?
What you want is "dirty read" semantics which none of the implemented
transaction isolation levels permit - so no you cannot go make an
uncommitted change and read the results from another session.
http://www.postgresql.org/docs/9.1/static/transaction-iso.html
That said I thought there was a project out there, probably related to data
recovery, that allows one to examine the system without respecting any
transactional boundaries.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Remote-troubleshooting-session-connection-tp5798810p5798823.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | David Rees | 2014-04-05 06:22:31 | Re: SSD Drives |
Previous Message | Scott Marlowe | 2014-04-05 00:20:20 | Re: SSD Drives |