Re: DISCARD ALL ; stored procedures

On Thu, Jan 6, 2011 at 3:20 PM, Stephen Frost <sfrost@snowman.net> wrote:
> Greetings,
>
>  Looking at discard all, I was a bit suprised that 'DISCARD PLANS;'
>  doesn't clear out cached stored procedures.  To be honest, that's one
>  of the main reasons I'd see to use it.  I thought there had been some
>  discussion in the archives related to invalidating stored procedure
>  plans due to catalog or other changes, I would have thought it'd be
>  possible to hook into that to do the same on a DISCARD PLANS;.
>
>  Thoughts?  Is there an issue doing that?  It certainly seems like it'd
>  be a lot better than what he current documentation requires:
>
>  When necessary, the cache can be flushed by starting a fresh database
>  session.
>
>  Maybe we could use 'DISCARD PLPLANS;' or something, if people feel
>  there needs to be a seperate way to clear those.

this is a problem. under what circumstances would you want to discard
them and why?  the main problem I see with cached plpgsql plans is
interactions with search_path -- but DISCARD might not be the best way
to attack that problem.  There might be other reasons though.

merlin