| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Hannu Krosing <hannu(at)tm(dot)ee>, Rod Taylor <rbt(at)zort(dot)ca>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Temporary Views |
| Date: | 2002-08-14 04:40:27 |
| Message-ID: | 200208140440.g7E4eR628428@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > so, added to TODO:
> > * Have views on temporary tables exist in the temporary namespace
> > TODO updated to remove mention of temporary views.
>
> That's *clearly* backwards. Ignoring our little argument, I think there
> is no denying that temp views as such are useful --- for example,
> consider a temp view created on permanent tables to define a
> session-local shorthand for a complex query.
Yes, if someone wants that, we can add such a capability to the TODO
list, it is just that no one has asked yet. What they have asked for is
proper handling of views on temporary tables, and we have only the drop
part of that, not the visiblity part, and frankly, without the
visibility part, it is pretty useless.
--
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 | Bruce Momjian | 2002-08-14 04:42:09 | Re: OOP real life example (was Re: Why is MySQL more |
| Previous Message | Christopher Kings-Lynne | 2002-08-14 04:38:55 | Inheritance |