| From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
|---|---|
| To: | Terry Brennan <terryjbrennan(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Request for new function in view update |
| Date: | 2023-06-02 01:43:16 |
| Message-ID: | c62a30ff-24e8-931b-1033-2b110dbddbed@iki.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 01/06/2023 13:18, Terry Brennan wrote:
> Hello all,
>
> I am a researcher in databases who would like to suggest a
> new function. I am writing to you because you have an active developer
> community. Your website said that suggestions for new functions should
> go to this mailing list. If there is another mailing list you prefer,
> please let me know.
You're in the right place.
> My research is in updating views -- the problem of translating an update
> in a view to an update to a set of underlying base tables. This problem
> has been partially solved for many years, including in PostgreSQL, but a
> complete solution hasn't been found.
Yeah, PostgreSQL only supports updating views in some simple cases [1].
Patches to handle more cases welcome.
[1]
https://www.postgresql.org/docs/current/sql-createview.html#SQL-CREATEVIEW-UPDATABLE-VIEWS
--
Heikki Linnakangas
Neon (https://neon.tech)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Suraj Kharage | 2023-06-02 03:30:13 | Re: postgres_fdw: wrong results with self join + enable_nestloop off |
| Previous Message | Dagfinn Ilmari Mannsåker | 2023-06-01 21:22:12 | Re: [PATCH] Missing dep on Catalog.pm in meson rules |