Horton

Re: Constraint's NO INHERIT option is ignored in CREATE TABLE LIKE statement

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amit Langote <amitlangote09@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Ildar Musin <ildar@adjust.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-03-10T18:55:20Z
Lists: pgsql-hackers 
Amit Langote <amitlangote09@gmail.com> writes:
> On Thu, Feb 20, 2020 at 8:20 AM David G. Johnston
> <david.g.johnston@gmail.com> wrote:
>> Not sure I agree with the premise that it is not supposed to be copied; is there some other object type the allows NO INHERIT that isn't copied when CREATE TABLE LIKE is used and check constraints are the odd ones out?

> Syntax currently allows only CHECK constraints to be marked NO INHERIT.

Hearing no further comments, pushed, with a bit of cosmetic polishing.

			regards, tom lane

Commits

  1. Ensure that CREATE TABLE LIKE copies any NO INHERIT constraint property.