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)
