Re: Why no CREATE TEMP MATERIALIZED VIEW ?

On 7/16/19 11:56 AM, David G. Johnston wrote:
> On Tue, Jul 16, 2019 at 9:29 AM Ivan Voras <ivoras(at)gmail(dot)com
> <mailto:ivoras(at)gmail(dot)com>> wrote:
>
> Out of curiosity, since there's CREATE TEMP VIEW, any particular
> reason there's no CREATE TEMP MATERIALIZED VIEW?
>
> Seems like it could be similar to a temp table.
>
>
> Probably a lack (absence) of use cases resulted in people deciding (or
> defaulting) to not spend any effort in that area. Incremental maintenance
> and refresh seem considerably less useful when only the current session
> can see the table. Temp views and temp tables seem to provide sufficient
> options in the session lifetime space.

How different is a "*temp* materialized view" from a regular view?

--
Angular momentum makes the world go 'round.