Re: Composite types for updatable views

2025-07-16 Thread DINESH NAIR
supported in an underlying table by primitive types. [1] https://www.postgresql.org/docs/current/sql-createview.html#SQL-CREATEVIEW-UPDATABLE-VIEWS Thanks Dinesh Nair From: Malthe Sent: Wednesday, July 16, 2025 5:36 PM To: Postgres hackers Subject: Composite typ

Composite types for updatable views

2025-07-16 Thread Malthe
While simple views are automatically updatable [1], this does not extend to composite types; that is, if a view constructs a composite type for one or more columns, this column then is not updatable: > A column is updatable if it is a simple reference to an updatable column of the underlying base