Neil Conway wrote:
> 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).
Yes, but how do you handle cases where the table gets create/dropped
inside the transaction. It is clearly tricky.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073