Re: PRIMARY KEYS

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: PRIMARY KEYS
Дата
Msg-id x7n0hgcmpy.fsf@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на Re: PRIMARY KEYS  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: PRIMARY KEYS  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
>>>>> "MvO" == Martijn van Oosterhout <kleptog@svana.org> writes:

MvO> Number or Drivers Licence number as primary key is forbidden. If
MvO> you're permitted to have the information you're allowed to store
MvO> it but you sure as hell can't index your filing cabinets on it or
MvO> make it a primary key.

What exactly is the difference between

UNIQUE INDEX on a NOT NULL column of driver license numbers with no
other primary key on that table

and

PRIMARY KEY on that same column?

The only thing that changed was the name.

But then, try explaining that to your lawmakers...

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: DBI connection to multiple database
Следующее
От: DeJuan Jackson
Дата:
Сообщение: Re: [HACKERS] about NULL