BUG #15678: The postgresql.conf string does not define server behavior (default_transaction_isolation)
От | PG Bug reporting form |
---|---|
Тема | BUG #15678: The postgresql.conf string does not define server behavior (default_transaction_isolation) |
Дата | |
Msg-id | 15678-af7076237c99dd87@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15678: The postgresql.conf string does not define serverbehavior (default_transaction_isolation)
Re: BUG #15678: The postgresql.conf string does not define serverbehavior (default_transaction_isolation) |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15678 Logged by: Vasiliy Korotkikh Email address: dhaenoor@yandex.ru PostgreSQL version: 11.2 Operating system: Debian Stretch Description: In the configuration file of my server there is the following line: default_transaction_isolation = 'serializable' I make a query like this: select current_setting('transaction_isolation') It displays this message: read committed The isolation level inside the functions also does not correspond to the one specified in the configuration file. For verification, I add into functions something like this: INSERT INTO t1(textval) VALUES (current_setting('transaction_isolation')); Also I used next query: ALTER ROLE ALL IN DATABASE mydb SET default_transaction_isolation TO 'serializable'; P.S. If in the future you want to get more sensible error reports, then you should think about a few examples. People understand examples better than lengthy documentation descriptions.
В списке pgsql-bugs по дате отправления: