Re: DISCARD ALL (Again) - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: DISCARD ALL (Again)
Date
Msg-id CAFcNs+p0Ro3oWC+H1+16yLVawj=SvCP=ztor9Fcc1OmSc1BH5A@mail.gmail.com
Whole thread
In response to Re: DISCARD ALL (Again)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers

On Fri, Apr 18, 2014 at 12:00 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
>
> On 4/17/14, 8:24 PM, Tom Lane wrote:
> > We could in fact implement #2, I imagine, by destroying and recreating
> > the entire language interpreter.  So I could imagine implementing a
> > "DISCARD INTERPRETERS" kind of command that would zap the current
> > interpreter(s) for whichever PL languages happened to feel like
> > cooperating with the command.
>
> More generally, any extension could maintain any kind of cross-call
> state.  plproxy, dblink, pgmemcache come to mind.  A general hook into
> DISCARD might be doable, but then it's not clear how to categorize this
> into DISCARD subcommands.
>

I proposed some like that in a previous message [1].

Regards,

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Avoiding deeply nested AND/OR trees in the parser
Next
From: Palle Girgensohn
Date:
Subject: Perfomance degradation 9.3 (vs 9.2) for FreeBSD