Re: BUG #14346: CREATE TABLE xxx (LIKE yyy INCLUDING ALL) fails

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #14346: CREATE TABLE xxx (LIKE yyy INCLUDING ALL) fails
Дата
Msg-id 19359.1475160368@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #14346: CREATE TABLE xxx (LIKE yyy INCLUDING ALL) fails  ("M. Roscio" <mroscio@tin.it>)
Список pgsql-bugs
Дерево обсуждения 
"M. Roscio" <mroscio@tin.it> writes:
> However I insist about foreign keys:  source table is present with 13
> rows in information_schema.key_column_usage,
> while destination table only has one.

LIKE is not documented as copying foreign key constraints, regardless
of whether there's a primary key or not.  INCLUDING CONSTRAINTS
is specifically stated to control CHECK constraints only.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint