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

Поиск
Список
Период
Сортировка
От aistrong.hs@gmail.com
Тема [BUGS] BUG #14836: Is there an option to change and run isolation level onlyfor a single statement as in DB2
Дата
Msg-id 20170929092841.28566.78613@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14834: quote_literal and composite types, different behaviour between sql and plpgsql
Следующее
От: gkostov79@gmail.com
Дата:
Сообщение: [BUGS] BUG #14837: pglogical subscription strange behavior