Postgres Pro
Downloads
Home   >   mailing lists

Re: Constraint's NO INHERIT option is ignored in CREATE TABLE LIKE statement - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Constraint's NO INHERIT option is ignored in CREATE TABLE LIKE statement
Date
Msg-id 1990.1583866520@sss.pgh.pa.us
Whole thread Raw
In response to Re: Constraint's NO INHERIT option is ignored in CREATE TABLE LIKE statement  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-hackers
Tree view 
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
NOINHERIT 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

pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: shared-memory based stats collector
Next
From: Justin Pryzby
Date:
Subject: Re: backend type in log_line_prefix?