Re: Why no CREATE TEMP MATERIALIZED VIEW ?

Ron <ronljohnsonjr@xxxxxxxxx> · Tue, 16 Jul 2019 12:57:55 -0500



    On 7/16/19 11:56 AM, David G. Johnston wrote:

    
          On Tue, Jul
              16, 2019 at 9:29 AM Ivan Voras <ivoras@xxxxxxxxx>
              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.