BUG #15678: The postgresql.conf string does not define server behavior (default_transaction_isolation) - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15678: The postgresql.conf string does not define server behavior (default_transaction_isolation)
Date
Msg-id 15678-af7076237c99dd87@postgresql.org
Whole thread Raw
Responses 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)
List 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 by date:

Previous
From: Daniel McCue
Date:
Subject: Re: table called 'configuration' cannot be dropped
Next
From: Evgeniy Efimkin
Date:
Subject: Re: BUG #15617: walsender hang if sync replica disconnected from network