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)