On Wed, 17 Jul 2019 at 15:42, Daniel Westermann (DWE) < daniel.westerm...@dbi-services.com> wrote:
> >______________________________________ > >From: Daniel Westermann (DWE) > >Sent: Monday, July 15, 2019 13:01 > >To: pgsql-hack...@postgresql.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
doc-alter-table-default-value-pg11.v1.patch
Description: Binary data
