| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Masse Jacques <jacques(dot)masse(at)bordeaux(dot)cemagref(dot)fr>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pl/pgsql create table |
| Date: | 2002-08-27 15:17:30 |
| Message-ID: | 200208271517.g7RFHU625068@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Neil Conway wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Kindness | 2002-08-27 15:45:42 | Re: how to count string occurrence in column |
| Previous Message | Neil Conway | 2002-08-27 15:09:07 | Re: pl/pgsql create table |