Re: quastions about primary key

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
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-24 15:14:11
Message-ID: 20030124071239.T30220-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 24 Jan 2003, jack wrote:

> Is that possible to have a two columns primary key on a table with null
> value on second column?

No, because primary key implies not null on all columns involved
(technically I think it's that a non-deferrable primary key implies
not null on all columns involved, but we don't support deferrable ones)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-01-24 15:32:16 Re: Scheduling Events?
Previous Message Achilleus Mantzios 2003-01-24 13:52:46 Re: Scheduling Events?