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