[BUGS] BUG #14877: DISCARD ALL incorrectly resets user parameters - Mailing list pgsql-bugs

From dmitriy@riabov.info
Subject [BUGS] BUG #14877: DISCARD ALL incorrectly resets user parameters
Date
Msg-id 20171027132152.1488.23907@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14877: DISCARD ALL incorrectly resets user parameters
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14877
Logged by:          Dmitriy Riabov
Email address:      dmitriy@riabov.info
PostgreSQL version: 10.0
Operating system:   Debian 8
Description:

Affected versions: 9.4 - 10. Versions prior to 9.4 haven't been tested.

How to reproduce the bug:

# psql testdb

testdb=# select current_setting('var.test');
ERROR:  unrecognized configuration parameter "var.test"
testdb=# select set_config('var.test', '123', false);set_config 
------------123
(1 row)

testdb=# select current_setting('var.test');current_setting 
-----------------123
(1 row)

testdb=# discard all;
DISCARD ALL
testdb=# select current_setting('var.test');current_setting 
-----------------
(1 row)



--
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: CONCHY Elisabeth
Date:
Subject: Re: [BUGS] BUG #14874: Dublicate values in primary key
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: [BUGS] BUG #14877: DISCARD ALL incorrectly resets user parameters