Re: DISCARD ALL ; stored procedures - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: DISCARD ALL ; stored procedures
Date
Msg-id 20110106213050.GM4933@tamriel.snowman.net
Whole thread Raw
In response to Re: DISCARD ALL ; stored procedures  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: DISCARD ALL ; stored procedures  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
* Merlin Moncure (mmoncure@gmail.com) wrote:
> 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.

interaction w/ search_path (or, rather, lack of respect for it..) is
exactly the issue here for me.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Patch to add a primary key using an existing index
Next
From: Merlin Moncure
Date:
Subject: Re: DISCARD ALL ; stored procedures