Re: UNIQUE constraint fails - Mailing list pgsql-general

From Tom Lane
Subject Re: UNIQUE constraint fails
Date
Msg-id 27995.982942687@sss.pgh.pa.us
Whole thread Raw
In response to UNIQUE constraint fails  (Louis-David Mitterrand <cunctator@apartia.ch>)
List pgsql-general
Louis-David Mitterrand <cunctator@apartia.ch> writes:
> With 7.1b4:
> test=# create table auction_type(id serial,login text,birthday timestamp);

> test=# create table auction(unique(login)) inherits("auction_type");
> ERROR:  inherited attribute "login" cannot be a PRIMARY KEY because it is not marked NOT NULL

This is fixed since 7.1b4.

            regards, tom lane

pgsql-general by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: Re: UNIQUE constraint fails
Next
From: Tom Lane
Date:
Subject: Re: Using NULL values in calculated results