From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(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 03:57:41 |
Message-ID: | 4351.1029297461@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
If you want a restriction, make it
* Invent temporary views
* Restrict permanent views from referring to temporary tables
I agree with the first goal and disagree with the second --- but I can
see your point of view on the second. OTOH I can't see any reason to
hardwire tempness-of-views to tempness-of-referenced-tables, because
that disallows the obviously useful case of temp view on permanent
table.
> I just removed them:
> * Allow temporary views
> * Require view using temporary tables to be temporary views
It was right the first time.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2002-08-14 04:06:01 | Re: Temporary Views |
Previous Message | Bruce Momjian | 2002-08-14 03:44:19 | Re: Temporary Views |