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
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

Re: CREATE UNLOGGED MATERIALIZED VIEW

2018-12-25 Thread Mitar
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

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-461

Re: Enerprisedb compatibility

2018-12-25 Thread Adrian Klaver
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

Enerprisedb compatibility

2018-12-25 Thread az....@outlook.es
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

Is there something wrong with my test case?

2018-12-25 Thread Thiemo Kellner
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

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