| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| 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:09:07 |
| Message-ID: | 87fzx09w4s.fsf@mailbox.samurai.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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).
Cheers,
Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-08-27 15:17:30 | Re: pl/pgsql create table |
| Previous Message | Bruce Momjian | 2002-08-27 15:05:20 | Re: pl/pgsql create table |