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

Поиск
Список
Период
Сортировка
От NikhilS
Тема Re: [BUGS] BUG #3774: create table like including index doesn't update pg_constraints with primary key
Дата
Msg-id d3c4af540712020014y10b0589bg17103dfd1175108d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #3774: create table like including index doesn't update pg_constraints with primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Steve Singer
Дата:
Сообщение: Re: [PATCHES] Re: [GENERAL] plperl and regexps with accented characters - incompatible?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: String encoding during connection "handshake"