Re: [BUGS] BUG #3774: create table like including index doesn't update pg_constraints with primary key - Mailing list pgsql-hackers

From NikhilS
Subject Re: [BUGS] BUG #3774: create table like including index doesn't update pg_constraints with primary key
Date
Msg-id d3c4af540712020014y10b0589bg17103dfd1175108d@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #3774: create table like including index doesn't update pg_constraints with primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

> The fundamental question though is should we allow primary, unique
> CONSTRAINTS which use the index mechanism just as an implementation to be
> created using the "INCLUDING INDEXES" mechanism.

Yeah, this bizarreness was foreseen and agreed to back when we set up
LIKE INCLUDING CONSTRAINTS the way it was defined (ie, copying only
CHECK constraints and not other things called constraints).  I was never
very thrilled with that definition myself, but it's a bit too late to
revisit it.
 
Yeah this is all confusing. I believe we should remove the following TODO now that the above has been checked in:
 
 
Regards,
Nikhils
--
EnterpriseDB               http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Steve Singer
Date:
Subject: Re: [PATCHES] Re: [GENERAL] plperl and regexps with accented characters - incompatible?
Next
From: Neil Conway
Date:
Subject: Re: String encoding during connection "handshake"