Re: [BUGS] BUG #14325: backup restore inherited constraint

Поиск
Список
Период
Сортировка
От Nikolay Samokhvalov
Тема Re: [BUGS] BUG #14325: backup restore inherited constraint
Дата
Msg-id CANNMO+JCLeMaGeQ0TbnjXpMFLzGhMydybqZhO8Bi32PX1EuK8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #14325: backup restore inherited constraint  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Tue, Sep 20, 2016 at 1:14 AM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Fri, Sep 16, 2016 at 3:27 PM,  <vbv256@yandex.ru> wrote:
> If child table has field with removed inherit constraint.
> In dump file this constraint not removed and data not restored correctly.
> Problem also exist in PostgreSQL 9.1. Before this version appropriate
> construction not used by me.
>
> -- --- to reproduce problem ----------
> bash$ psql template1
> template1=# create database test;
> template1=# \c test
>
> [... test ...]

What we ought to do here is forbid DROP NOT NULL on the table test.

+1 for this approach. Just encountered with the same behavior.

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

Предыдущее
От: Sergey Koposov
Дата:
Сообщение: Re: [BUGS] BUG #14722: Segfault in tuplesort_heap_siftup, 32 bitoverflow
Следующее
От: "K S, Sandhya (Nokia - IN/Bangalore)"
Дата:
Сообщение: [BUGS] Postgres process invoking exit resulting in sh-QUIT core