Re: Is there any different for foreign key to be serial instead of integer

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Is there any different for foreign key to be serial instead of integer
Дата
Msg-id 396486431001062039x5b82370do1b13273a31604ce1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is there any different for foreign key to be serial instead of integer  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
On Wed, Jan 6, 2010 at 8:36 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>.  A
>> serial foreign key would be nonsensical since foreign keys should be
>> be generating their own values.
>
> Pretty sure the OP was talking about referencing a bigserial from a
> foreign key, which makes perfect sense for certain types of mappings.
> FKs don't generate their own values, they reference values in a PK or
> unique field somewhere else really.

Good catch. :)  I've been sticking my foot in my mouth all day with
typos like this.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Is there any different for foreign key to be serial instead of integer
Следующее
От: Greg Smith
Дата:
Сообщение: Re: PostgreSQL Write Performance