Re: Errors when update a view with conditional-INSTEAD rules

From: Pengzhou Tang <ptang(at)pivotal(dot)io>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Errors when update a view with conditional-INSTEAD rules
Date: 2020-01-22 06:28:01
Message-ID: CAG4reARgyiAM6EtvEqu0q9-X32fowR9_+So0gNU=FjBZ=D35+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I am wondering whether a simple auto-updatable view can have a
> conditional update instead rule.
>
> Well, the decision reached in [1] was that we wouldn't allow that. We
> could decide to allow it now as a new feature enhancement, but it
> wouldn't be a back-patchable bug-fix, and to be honest I wouldn't be
> particularly excited about adding such a feature now. We already get
> enough reports related to multiple rule actions behaving in
> counter-intuitive ways that trip up users. I don't think we should be
> enhancing the rule system, but rather encouraging users not to use it
> and use triggers instead.
>
> Ok, that makes sense, thanks for the explanation.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2020-01-22 06:31:00 Re: [Proposal] Global temporary tables
Previous Message Surafel Temesgen 2020-01-22 06:19:46 Re: FETCH FIRST clause WITH TIES option