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.

  	Thanks,

		Stephen

Responses

• Re: DISCARD ALL ; stored procedures at 2011-01-06 21:21:36 from Merlin Moncure

pgsql-hackers by date

Next:	From: Robert Haas	Date: 2011-01-06 20:32:29
	Subject: Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE
Previous:	From: Bruce Momjian	Date: 2011-01-06 19:59:41
	Subject: Re: psql expanded auto