| From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
|---|---|
| To: | dmitriy(at)riabov(dot)info |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14877: DISCARD ALL incorrectly resets user parameters |
| Date: | 2017-10-27 13:43:30 |
| Message-ID: | CAFcNs+ra_gJW5iSNsUXR9t3DNS0R2noamqMFEbcNda93T7h-yg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Oct 27, 2017 at 11:21 AM, <dmitriy(at)riabov(dot)info> wrote:
>
> 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)
>
Why do you think this wrong? This is the default behavior of DISCARD ALL
since when 8.3 introduced it.
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-10-27 14:05:44 | Re: BUG #14877: DISCARD ALL incorrectly resets user parameters |
| Previous Message | dmitriy | 2017-10-27 13:21:52 | BUG #14877: DISCARD ALL incorrectly resets user parameters |