Re: pl/pgsql create table

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> When referencing created/dropped tables in pl/pgsql, use EXECUTE to
> prevent the table oid from being stored in function as precompiled.  It
> is mentioned in the current FAQ.  The solution is for us to
> automatically add EXECUTE somehow.

IMHO, no -- the solution is to automatically invalidate compiled query
plans when a dependant relation is removed. Not exactly sure how to do
it, but I was thinking of tackling this for 7.4 (suggestions are
welcome, of course).

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC