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

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default
Дата
Msg-id CAA8=A7_z8fYpg_nmKLc=EYHeAQY02VP1kyQ1FGhgjF3cBUtiyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: pgsql: Optimize btree insertions for common case of increasing values
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default