Re: Fw: Documentation fix for adding a column with a default value

On Wed, 17 Jul 2019 at 15:42, Daniel Westermann (DWE) <
daniel(dot)westermann(at)dbi-services(dot)com> wrote:

> >______________________________________
> >From: Daniel Westermann (DWE)
> >Sent: Monday, July 15, 2019 13:01
> >To: pgsql-hackers(at)postgresql(dot)org
> >Subject: Documentation fix for adding a column with a default value
> >
> >Hi,
> >
> >the tip in the "Adding a column" section is not true anymore since
> PostgreSQL 11:
> >
>
> >https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-ADDING-A-COLUMN
> <https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-ADDING-A-COLUMN>
> >
> >Attached a patch proposal for this.
>
> Seems the first mail didn't make it ...
>

Actually it did, I was about to reply to it :)

The suggested change pares down the "Tip" to more of a brief "Note", which
IMHO is a bit
terse for that section of the documentation (which has more of a tutorial
character),
and the contents of the original tip basically still apply for volatile
default values
anyway.

I've attached another suggestion for rewording this which should also make
the
mechanics of the operation a little clearer.

Regards

Ian Barwick

--
Ian Barwick https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services