| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Supporting MERGE on updatable views |
| Date: | 2022-12-21 20:04:26 |
| Message-ID: | CAEZATCWaObw0viFYGURDt3qLt7TjJk+M1xNa30GdeuJPF8_3EA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 8 Dec 2022 at 10:03, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
>
> Attached is a WIP patch, which I'll add to the next CF. I still need
> to do more testing, and update the docs, but so far, everything
> appears to work.
>
New patch attached with doc updates and a few other, mostly cosmetic, changes.
One notable change is that I realised that the check for rules on the
target table needs to be done in the rewriter, rather than the parser,
in case expanding a view hierarchy leads to base relations with rules
that the parser wouldn't notice.
Regards,
Dean
| Attachment | Content-Type | Size |
|---|---|---|
| support-merge-into-view-v2.patch | text/x-patch | 120.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2022-12-21 20:59:42 | Re: assertion failures on BuildFarm that happened in slab.c |
| Previous Message | Tom Lane | 2022-12-21 19:45:13 | Re: Array initialisation notation in syscache.c |