Postgres Pro
Downloads
Home   >   mailing lists

[BUGS] BUG #14836: Is there an option to change and run isolation level onlyfor a single statement as in DB2 - Mailing list pgsql-bugs

From aistrong.hs@gmail.com
Subject [BUGS] BUG #14836: Is there an option to change and run isolation level onlyfor a single statement as in DB2
Date
Msg-id 20170929092841.28566.78613@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      14836
Logged by:          Isaac  Arasavalli
Email address:      aistrong.hs@gmail.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


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14834: quote_literal and composite types, different behaviour between sql and plpgsql
Next
From: gkostov79@gmail.com
Date:
Subject: [BUGS] BUG #14837: pglogical subscription strange behavior