Re: pl/pgsql create table

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