Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14346: CREATE TABLE xxx (LIKE yyy INCLUDING ALL) fails - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14346: CREATE TABLE xxx (LIKE yyy INCLUDING ALL) fails
Date
Msg-id 19359.1475160368@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #14346: CREATE TABLE xxx (LIKE yyy INCLUDING ALL) fails  ("M. Roscio" <mroscio@tin.it>)
List pgsql-bugs
Tree view 
"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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file
Next
From: Kevin Grittner
Date:
Subject: Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint