BUG #14877: DISCARD ALL incorrectly resets user parameters

From: dmitriy(at)riabov(dot)info
To: pgsql-bugs(at)postgresql(dot)org
Cc: dmitriy(at)riabov(dot)info
Subject: BUG #14877: DISCARD ALL incorrectly resets user parameters
Date: 2017-10-27 13:21:52
Message-ID: 20171027132152.1488.23907@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14877
Logged by: Dmitriy Riabov
Email address: dmitriy(at)riabov(dot)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)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2017-10-27 13:43:30 Re: BUG #14877: DISCARD ALL incorrectly resets user parameters
Previous Message CONCHY Elisabeth 2017-10-27 11:01:48 Re: BUG #14874: Dublicate values in primary key