Re: Request for new function in view update

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)