"Ingmar Brouns" <swi...@gmail.com> writes: > Description: pl/pgsql plans are not invalidated on discard all
Yes they are. > I ran into the pl/pgsql Plan Invalidation and search_path bug that is on the > todo list > http://wiki.postgresql.org/wiki/Todo#PL.2FpgSQL > I was looking for a workaround to this problem, and figured that calling > 'discard all', or 'discard plans' should do the trick. That's not a solution because the plancache module intentionally preserves the original search_path value while replanning. This may not be what you wished for, but it's operating as intended, and changing it would break other use-cases that work today. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
