View Single Post

   
  #2 (permalink)  
Old 04-15-2008, 10:48 PM
Merlin Moncure
 
Posts: n/a
Default Re: pl/pgsql Plan Invalidation and search_path

On Mon, Mar 24, 2008 at 9:48 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
> Add to pl/pgsql TODO:
>
> o Consider invalidating the cache or keeping seperate cached
> copies when search_path changes
>
> http://archives.postgresql.org/pgsql...1/msg01009.php


IMO, Tom's idea, namely to keep separate cache plans for various
search_path settings, is a much stronger proposal and should probably
get the 'todo'.

merlin

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply With Quote