Re: CREATE UNLOGGED MATERIALIZED VIEW

2018-12-27 Thread Mitar
the comment above because they do not exit after the crash anyway. Mitar On Wed, Dec 26, 2018 at 8:35 AM Tom Lane wrote: > > Mitar writes: > > I am looking at parser grammar rules and it looks like the following > > is a valid query: > > CREATE UNLOGGED MATERIALIZED VIEW &

Re: CREATE UNLOGGED MATERIALIZED VIEW

2018-12-26 Thread Tom Lane
Mitar writes: > I am looking at parser grammar rules and it looks like the following > is a valid query: > CREATE UNLOGGED MATERIALIZED VIEW > Any particular reason this is not documented? Because it's not supported: regression=# CREATE UNLOGGED MATERIALIZED VIEW foo A

Re: CREATE UNLOGGED MATERIALIZED VIEW

2018-12-25 Thread Mitar
Hi! On Tue, Dec 25, 2018 at 10:25 AM Adrian Klaver wrote: > Don't know. From my POV MATERIALIZED VIEWS are transient any way you > look at them. They capture a state at a point in time and then the data > they depend on moves on. Given that they can be refreshed at will not > sure logging/not log

Re: CREATE UNLOGGED MATERIALIZED VIEW

2018-12-25 Thread Adrian Klaver
query: CREATE UNLOGGED MATERIALIZED VIEW Any particular reason this is not documented? My guess because of this: https://doxygen.postgresql.org/matview_8c.html Line 458-461 "/* * We can skip WAL-logging the insertions, unless PITR or streaming * replication is in use. We can sk

Re: CREATE UNLOGGED MATERIALIZED VIEW

2018-12-25 Thread Mitar
e the following > > is a valid query: > > > > CREATE UNLOGGED MATERIALIZED VIEW > > > > Any particular reason this is not documented? > > My guess because of this: > > https://doxygen.postgresql.org/matview_8c.html > > Line 458-461 > > &

Re: CREATE UNLOGGED MATERIALIZED VIEW

2018-12-25 Thread Adrian Klaver
On 12/25/18 1:13 AM, Mitar wrote: Hi! I am looking at parser grammar rules and it looks like the following is a valid query: CREATE UNLOGGED MATERIALIZED VIEW Any particular reason this is not documented? My guess because of this: https://doxygen.postgresql.org/matview_8c.html Line 458

CREATE UNLOGGED MATERIALIZED VIEW

2018-12-25 Thread Mitar
Hi! I am looking at parser grammar rules and it looks like the following is a valid query: CREATE UNLOGGED MATERIALIZED VIEW Any particular reason this is not documented? Mitar -- http://mitar.tnode.com/ https://twitter.com/mitar_m