Re: Unique or Primary Key? - Mailing list pgsql-general

From Bruce Richardson
Subject Re: Unique or Primary Key?
Date
Msg-id 20010503.17004700@usb.cafod
Whole thread Raw
In response to Re: Unique or Primary Key?  (GH <grasshacker@over-yonder.net>)
Responses RE: Unique or Primary Key?  ("Christian Marschalek" <cm@chello.at>)
List pgsql-general
On 5/3/01, 2:29:09 AM, GH <grasshacker@over-yonder.net> wrote regarding
Re: [GENERAL] Unique or Primary Key?:



> Just to expand on Eric's response, a Primary Key directive creates a
> unique not null column, whereas a unique column can be null. In this
> instance, your columns are already not null, so, as Eric responded, it
is
> basically the same thing.

OK.  I was just worried that there might be some more subtle issues
regarding query/index optimisation.

Besides, I couldn't see much use in creating it as a primary key.  How
would I ever reference it from another table?

--

Bruce





pgsql-general by date:

Previous
From: "Gyozo Papp"
Date:
Subject: Re: [PHP] psql with PHP question
Next
From: Lamar Owen
Date:
Subject: Re: Ideal hardware configuration for pgsql