pg_dump fails on domain constraint comments

Поиск
Список
Период
Сортировка
От Elvis Pranskevichus
Тема pg_dump fails on domain constraint comments
Дата
Msg-id 3789929.ZsF6ME7o6i@klinga.prans.org
обсуждение исходный текст
Ответы Re: pg_dump fails on domain constraint comments  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
Hello Alvaro,

It looks like pg_dump emits incorrect text for domain constraint comments:

Assuming the following structure,

CREATE DOMAIN "dom" AS integer
        CONSTRAINT "dom_constraint" CHECK ((VALUE > 10));

COMMENT ON CONSTRAINT "dom_constraint" ON DOMAIN "dom" IS 'domain constraint comment'

pg_dump will dump the COMMENT as follow:

COMMENT ON CONSTRAINT "dom_constraint" ON DOMAIN """dom""" IS 'domain constraint comment'

Note the double-quoting issue of the domain name.

Attached patch fixes that.

                                    Elvis

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Speedup twophase transactions
Следующее
От: Stas Kelvich
Дата:
Сообщение: Re: Speedup twophase transactions