Hi,
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).
I can understand why this behaviour was required when addin
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
imer on my initial email, I tried to stop
it!
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
