Re: quastions about primary key - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: quastions about primary key
Date
Msg-id 20030124071239.T30220-100000@megazone23.bigpanda.com
Whole thread Raw
In response to quastions about primary key  ("jack" <datactrl@tpg.com.au>)
List 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)




pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Scheduling Events?
Next
From: Tom Lane
Date:
Subject: Re: Scheduling Events?