Hi!
FYI, I started working on also adding TEMPORARY materialized views. [1]
[1]
https://www.postgresql.org/message-id/CAKLmikOwqJx7J%3Dfg7VFcuk2OUjqLy%3DHZj_J5stY1x8X7%2B14g5g%40mail.gmail.com
UNLOGGED is still unsupported, but TEMPORARY materialized views do not
have the issue mentioned in the
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 AS select 1;
ERROR: materia
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
On 12/25/18 10:16 AM, Mitar wrote:
Hi!
That is for transient tables (NEW and OLD tables), no? Not for the
main materialized view table.
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
Hi!
That is for transient tables (NEW and OLD tables), no? Not for the
main materialized view table.
Mitar
On Tue, Dec 25, 2018 at 10:14 AM Adrian Klaver
wrote:
>
> 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 v
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-461
