Re: quastions about primary key

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: jack <datactrl(at)tpg(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: quastions about primary key
Date: 2003-01-26 04:23:39
Message-ID: 20030126042339.GA11365@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sun, Jan 26, 2003 at 12:29:12 +1000,
jack <datactrl(at)tpg(dot)com(dot)au> wrote:
>
> I try use uique instead of primary key. And it works, it allows null values.
> Is there any other difference between primary key and unique?

I believe that the primary key is the default key for foreign key references
into a table.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David Durst 2003-01-26 08:41:00 ERROR: Cannot display a value of type RECORD
Previous Message Bruce Momjian 2003-01-26 03:51:30 Re: returning setof in plpgsql