Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default - Mailing list pgsql-committers

From Andrew Dunstan
Subject Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default
Date
Msg-id CAA8=A7_z8fYpg_nmKLc=EYHeAQY02VP1kyQ1FGhgjF3cBUtiyQ@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Tree view 
On Wed, Mar 28, 2018 at 3:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andres Freund <andres@anarazel.de> writes:
>> The one I noticed was:
>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=treepie&dt=2018-03-28%2002%3A43%3A00
>> ...
>> which probably is just collation related and will stably fail?
>
> Yeah, magpie is still showing that after the latest commits.
> A bit of COLLATE "C" might fix it.
>

Just testing a fix along those lines now.

cheers

andrew


-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-committers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: pgsql: Optimize btree insertions for common case of increasing values
Next
From: Andres Freund
Date:
Subject: Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default