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