On Thu, Feb 20, 2020 at 8:20 AM David G. Johnston <david.g.johns...@gmail.com> wrote: > On Wed, Feb 19, 2020 at 4:02 PM Tom Lane <t...@sss.pgh.pa.us> wrote: >> Ildar Musin <il...@adjust.com> writes: >> > My colleague Chris Travers discovered something that looks like a bug. >> > Let's say we have a table with a constraint that is declared as NO INHERIT. >> > ... >> > Now when we want to make a copy of the table structure into a new table >> > the `NO INHERIT` option is ignored. >> >> Hm, I agree that's a bug, since the otherwise-pretty-detailed CREATE TABLE >> LIKE documentation makes no mention of such a difference between original >> and cloned constraint. >> >> However, I'd be disinclined to back-patch, since it's barely possible >> somebody out there is depending on the existing behavior. > > 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. Thanks, Amit
