Re: Re: Feature: triggers on materialized views

From: Mitar <mmitar(at)gmail(dot)com>
To: David Steele <david(at)pgmasters(dot)net>
Cc: Nguyễn Trần Quốc Vinh <ntquocvinh(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Re: Feature: triggers on materialized views
Date: 2019-03-14 08:05:59
Message-ID: CAKLmikMuJoH_TbVWQau0AVNbpKUkM3s6Mo8UZE608XmWyXJYwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

On Thu, Mar 7, 2019 at 12:13 AM David Steele <david(at)pgmasters(dot)net> wrote:
> There doesn't seem to be consensus on whether or not we want this patch.
> Peter has issues with the way it works and Andres [1] thinks it should
> be pushed to PG13 or possibly rejected.
>
> I'll push this to PG13 for now.

Sorry, I am new to PostgreSQL development process. So this has been
pushed for maybe (if at all) release planned for 2020 and is not
anymore in consideration for PG12 to be released this year? From my
very inexperienced eye this looks like a very far push. What is
expected to happen in the year which would make it clearer if this is
something which has a chance of going and/or what should be improved,
if improving is even an option? I worry that nothing will happen for a
year and we will all forget about this and then we will be all to
square zero.

I must say that i do not really see a reason why this would not be
included. I mean, materialized views are really just a sugar on top of
having a table you refresh with a stored query, and if that table can
have triggers, why not also a materialized view.

Mitar

--
http://mitar.tnode.com/
https://twitter.com/mitar_m

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Edmund Horner 2019-03-14 08:12:15 Re: Tid scan improvements
Previous Message Kyotaro HORIGUCHI 2019-03-14 08:05:24 Re: Is PREPARE of ecpglib thread safe?