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
On 12/25/18 3:53 AM, az@outlook.es wrote:
Hello,
We would like to upgrade an database from postgresql installation
to enterprisedb platform.
You are going to have to be more specific:
1) What is your current Postgres version and source?
2) What EDB platform are you referring to and
Hello,
We would like to upgrade an database from postgresql installation to
enterprisedb platform.
Do you know if there is any guide to follow in this case?
Thanks, Carlos
Hi all and merry Christmas
I was under the impression that updating a table with values from (an)
other table(s) would be implemented most efficiently with a correlated
subquery a long the schema as follows, let's name it A.
update TO_BE_UPDATED U
set ({column list}) = ({correlated subqu
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