Re: UNIQUE constraint fails

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: UNIQUE constraint fails
Date: 2001-02-23 15:41:31
Message-ID: 20010223164131.A814@apartia.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 23, 2001 at 10:38:07AM -0500, Tom Lane wrote:
> 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.

Thanks Tom.

I hope Oliver Elphick will soon issue updated Debian packages (hint,
hint ;)

--
OENONE: Un dsordre ternel rgne dans son esprit.
Son chagrin inquiet l'arrache de son lit.
(Phdre, J-B Racine, acte 1, scne 2)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-23 15:42:34 Re: Using NULL values in calculated results
Previous Message Tom Lane 2001-02-23 15:38:07 Re: UNIQUE constraint fails