Re: Review of patch renaming constraints

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Review of patch renaming constraints
Дата
Msg-id 1327184035.4482.15.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: Review of patch renaming constraints  (Nikhil Sontakke <nikkhils@gmail.com>)
Список pgsql-hackers
On fre, 2012-01-20 at 11:32 +0530, Nikhil Sontakke wrote:
> Agreed. And right now primary key constraints are not marked as only
> making them available for inheritance in the future. Or you prefer it
> otherwise?
> 
> Anyways, fail to see the direct connection between this and renaming.
> Might have to look at this patch for that.

It checks conisonly to determine whether it needs to rename the
constraint in child tables as well.  Since a primary has conisonly =
false, it goes to the child tables, but the constraint it not there.

In the past, we have treated this merely as an implementation artifact:
check constraints are inherited, primary key constraints are not.  Now
we can choose for check constraints, with inherited being the default.
Having inheritable primary key constraints is a possible future feature.
So we need to think a littler harder now how to work that into the
existing logic.  This also ties in with the other thread about having
this in CREATE TABLE syntax.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: [PATCH] Support for foreign keys with arrays
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter