st 26. 12. 2018 v 18:20 odesÃlatel Mitar <mmi...@gmail.com> napsal: > Hi! > > On Wed, Dec 26, 2018 at 9:00 AM Alvaro Herrera <alvhe...@2ndquadrant.com> > wrote: > > I think MVs that are dropped at session end are a sensible feature. > > Thanks. > > > I probably wouldn't go as far as allowing ON COMMIT actions, though > > I agree. I do not see much usefulness for it. The only use case I can > think of would be to support REFRESH as an ON COMMIT action. That > would be maybe useful in the MV setting. After every transaction in my > session, REFRESH this materialized view. > > But personally I do not have an use case for that, so I will leave it > to somebody else. :-) > > > I think if you really want to do this you should just use OptTemp, and > > delete OptNoLog. > > Sounds good. > > OptTemp seems to have a misleading warning in some cases when it is > not used on tables though: > > "GLOBAL is deprecated in temporary table creation" > > Should we change this language to something else? "GLOBAL is > deprecated in temporary object creation"? Based on grammar it seems to > be used for tables, views, sequences, and soon materialized views. >
This message is wrong - probably better "GLOBAL temporary tables are not supported" Regards Pavel > > > Of course, you need to add tests and patch the docs. > > Sure. > > [1] https://www.postgresql.org/message-id/29165.1545842105%40sss.pgh.pa.us > > > Mitar > > -- > http://mitar.tnode.com/ > https://twitter.com/mitar_m > >