Re: Primary key inheritance problem

Поиск
Список
Период
Сортировка
От Matthew M Davis
Тема Re: Primary key inheritance problem
Дата
Msg-id 20040829170739.GA13465@localhost
обсуждение исходный текст
Ответ на Re: Primary key inheritance problem  (Oliver Elphick <olly@lfix.co.uk>)
Ответы Re: Primary key inheritance problem  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-general
On Sunday 29 August at 12:34pm, Oliver Elphick had this to say:

> Primary and foreign key constraints are not inherited.  This is a defect
> in the current system.

It almost seems like a FEATURE to me, since it creates a different and
easy way to create one-to-many relationships.  But I didn't use it,
since the documentation says this is a Bad Thing that may be fixed
some day.  If the child table inherits the primary key constraint from
the parent, why not just put it in the same table?

--

Matthew M Davis
<mmd@teledavis.com>

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Migrating between versions. Problem with regexp
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: Primary key inheritance problem