Re: UNIQUE constraint fails

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UNIQUE constraint fails
Date: 2001-02-23 15:38:07
Message-ID: 27995.982942687@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Louis-David Mitterrand <cunctator(at)apartia(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Louis-David Mitterrand 2001-02-23 15:41:31 Re: UNIQUE constraint fails
Previous Message Wayne Ward 2001-02-23 15:14:00 install problem.