On 2024-11-01 09:25:24, David Rowley wrote:
> We have the ability to store immutable defaults in the catalogue tables and
> "fill in the blanks" from there for any tuples that don't have the new
> column. Since we only can store 1 value per column, it must be a constant,
> i.e. the same for all r
Hi folks,
We have this Tip box under the "Adding a Column" header here:
-
https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-ADDING-A-COLUMN
That says:
> From PostgreSQL 11, adding a column with a constant default value no longer
> means that each row of the table needs to be upd
