Skip site navigation (1) Skip section navigation (2)

Re: DISCARD ALL ; stored procedures

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DISCARD ALL ; stored procedures
Date: 2011-01-06 21:30:50
Message-ID: 20110106213050.GM4933@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-hackers
* Merlin Moncure (mmoncure(at)gmail(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Merlin MoncureDate: 2011-01-06 22:09:12
Subject: Re: DISCARD ALL ; stored procedures
Previous:From: Gurjeet SinghDate: 2011-01-06 21:28:19
Subject: Re: Patch to add a primary key using an existing index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group