On Fri, Nov 1, 2024 at 5:06 PM Marcelo Fernandes wrote:
>
> 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
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
On Fri, 1 Nov 2024 at 22:06, Marcelo Fernandes wrote:
> -
> 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 updated wh
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
