From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
To: Bruce Momjian <bruce@momjian.us>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Teodor Sigaev <teodor@sigaev.ru>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Postgres 11 release notes
Date: Mon, 14 May 2018 07:47:54 -0400
Message-ID: <6a28a9c2-d1aa-966c-e1f4-848750de2189@2ndQuadrant.com> (raw)
In-Reply-To: <20180513004708.GA15365@momjian.us>
References: <20180511150852.GA18510@momjian.us>
<f88a4718-7d0c-b05c-7fde-90b23b3c1892@sigaev.ru>
<20180511184406.GD18510@momjian.us>
<aebf5f72-02a2-61e1-008f-525169e48474@sigaev.ru>
<20180511210652.GK18510@momjian.us>
<CAH2-WzkBcFCZGGFk7YAcBJ1v6hU3SBZFSD1AqrHxMQm_xknkDA@mail.gmail.com>
<20180513004708.GA15365@momjian.us>
On 05/12/2018 08:47 PM, Bruce Momjian wrote:
> On Sat, May 12, 2018 at 01:22:55PM -0700, Peter Geoghegan wrote:
>> On Fri, May 11, 2018 at 2:06 PM, Bruce Momjian <bruce@momjian.us> wrote:
>>> Done and URL updated.
>> I have some feedback on "Allow NOT NULL to be added to columns without
>> requiring a table rewrite". I suggest that this be phrased as "Avoid a
>> table rewrite when ALTER TABLE ADD COLUMN sets a default value for a
>> column". Referencing the fact that Postgres was previously able to do
>> this with a NULL default doesn't seem to add anything.
> Agreed, done:
>
> Allow <command>ALTER TABLE</command> to add a non-null default
> column without a table rewrite (Andrew Dunstan, Serge Rielau)
>
I think "a column with a non-null default" would be a bit clearer than
"a non-null default column".
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-www@postgresql.org
Cc: andrew.dunstan@2ndquadrant.com, bruce@momjian.us, pg@bowt.ie, teodor@sigaev.ru, pgsql-hackers@postgresql.org
Subject: Re: Postgres 11 release notes
In-Reply-To: <6a28a9c2-d1aa-966c-e1f4-848750de2189@2ndQuadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox