Re: Temporary Views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Temporary Views
Date
Msg-id 26381.1029253429@sss.pgh.pa.us
Whole thread Raw
In response to Re: Temporary Views  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Temporary Views  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Temporary Views  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I can go either way on this.

AFAICS "create temp view" would have some small advantage of keeping the
view's name out of possibly-public permanent namespaces, so the step of
just adding the TEMP option to CREATE VIEW may be worth doing.  The
advantage isn't very big but neither is the amount of work.

Trying to prohibit non-temp views on temp tables strikes me as more work
than it's worth; that TODO item was written before we had dependencies,
and I think it's obsolete.  Basically the point of the TODO was to avoid
having broken views --- and we have solved that problem.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Temporary Views
Next
From: Bruce Momjian
Date:
Subject: Re: Temporary Views