The following bug has been logged on the website:
Bug reference: 14836
Logged by: Isaac Arasavalli
Email address: aistrong(dot)hs(at)gmail(dot)com
PostgreSQL version: 9.3.0
Operating system: Any
Description:
If a transaction is started and some isolation level li repeatable read is
set.
Then if lock will be set.
And I want to read uncommitted rows.
How can I?
In db2 we can run a statement like
SELECT * FROM X WITH CS;
meaning cursor stability read uncommitted.
Is this available in postgres?
Or any turn around work can be done. Without making other transaction give
error like couldnt serialize or aborted.
Please give me little detailed solution