Re: pg_ugprade test failure on data set with column with default valuewith type bit/varbit

Поиск
Список
Период
Сортировка
От Davy Machado
Тема Re: pg_ugprade test failure on data set with column with default valuewith type bit/varbit
Дата
Msg-id 153222608873.1561.2579913781159881783.pgcf@coridan.postgresql.org
обсуждение исходный текст
Ответ на Re: pg_ugprade test failure on data set with column with defaultvalue with type bit/varbit  (Paul Guo <paulguo@gmail.com>)
Список pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  tested, passed
Implements feature:       tested, passed
Spec compliant:           tested, passed
Documentation:            not tested

Hi Paul,

this is a review of the patch:
CABQrizc90sfkZgi4=+0Bbp1Zu3yEx9sM4rjBE1YNCvzf3qKHkA@mail.gmail.com

There hasn't been any problem, at least that I've been able to find.

This one applies cleanly. 

Compile, pg_upgrade and pg_dumpall passed without error too.

Follow below a comparison of the results of the pg_dumpall:

############# Without patch #############

...

CREATE TABLE public.t111 (
    a40 bit varying(5) DEFAULT (B'1'::"bit")::bit varying
);

...

CREATE TABLE public.t222 (
    a40 bit varying(5) DEFAULT B'1'::"bit"
);

############# With patch #############

...

CREATE TABLE public.t111 (
    a40 bit varying(5) DEFAULT ('1'::"bit")::bit varying
);

...

CREATE TABLE public.t222 (
    a40 bit varying(5) DEFAULT '1'::"bit"
);


The "B", used to indicated a bit-string constant, removed as expected.

+1 for committer review

--
Davy Machado

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrei Korigodski
Дата:
Сообщение: pgbench: improve --help and --version parsing
Следующее
От: Charles Cui
Дата:
Сообщение: Re: project updates