Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: [BUGS] BUG #14877: DISCARD ALL incorrectly resets user parameters
Date
Msg-id CAKFQuwbQ40dUuNbQb8R9h53WD1LOV2dVEJv=LydJLwt+dxZQGw@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14877: DISCARD ALL incorrectly resets user parameters  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-bugs
Tree view
On Fri, Oct 27, 2017 at 7:22 AM, Fabrízio de Royes Mello <fabriziomello@gmail.com> wrote:
On Fri, Oct 27, 2017 at 12:05 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

I wonder if be nice to have some new DISCARD construct to cover different use cases, something like:

DISCARD { ALL | PLANS | TEMP | SEQUENCES | ( { SESSION AUTHORIZARION | RESET | PREPARED STATEMENT | CURSORS | NOTIFY | ADVISORY LOCKS | PLANS | SEQUENCES | TEMP } [, ...] ) }


​DISCARD ALL ( RESET false ) ...​

David J.

pgsql-bugs by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: [BUGS] BUG #14877: DISCARD ALL incorrectly resets user parameters
Next
From: Jordan Lewis
Date:
Subject: [BUGS] ORDER BY $1 behaves inconsistently