Re: PRIMARY KEYS - Mailing list pgsql-general

From Vivek Khera
Subject Re: PRIMARY KEYS
Date
Msg-id x7n0hgcmpy.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to Re: PRIMARY KEYS  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: PRIMARY KEYS  (Martijn van Oosterhout <kleptog@svana.org>)
List 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 by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: DBI connection to multiple database
Next
From: DeJuan Jackson
Date:
Subject: Re: [HACKERS] about NULL