Re: Behaviour adding a column with and without a default (prior to PG11)

Hi Tom, Just thinking about this further, there are other areas where Postgres (correctly, IMO) deviates from the SQL spec and clarifies that in the docs. For example, https://www.postgresql.org/docs/10/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL states that for a NUMERIC with no precision

Re: Behaviour adding a column with and without a default (prior to PG11)

Thanks for the quick response Tom. Cheers, Joe. On 30/09/2019, 22:19, "Tom Lane" wrote: Joe Horsnell writes: > The documentation (https://www.postgresql.org/docs/10/ddl-alter.html) clearly states that adding a column with a default requires updating all the rows in the table, to st

Re: Behaviour adding a column with and without a default (prior to PG11)

Joe Horsnell writes: > The documentation (https://www.postgresql.org/docs/10/ddl-alter.html) clearly > states that adding a column with a default requires updating all the rows in > the table, to store the new column value (this is prior to PG11, obviously). > Obviously the desired effect of ad