Re: UNIQUE constraint fails - Mailing list pgsql-general

From Louis-David Mitterrand
Subject Re: UNIQUE constraint fails
Date
Msg-id 20010223164131.A814@apartia.ch
Whole thread Raw
In response to UNIQUE constraint fails  (Louis-David Mitterrand <cunctator@apartia.ch>)
List pgsql-general
On Fri, Feb 23, 2001 at 10:38:07AM -0500, Tom Lane wrote:
> 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.

Thanks Tom.

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

--
    OENONE: Un d�sordre �ternel r�gne dans son esprit.
            Son chagrin inquiet l'arrache de son lit.
                                          (Ph�dre, J-B Racine, acte 1, sc�ne 2)

pgsql-general by date:

Previous
From: Renaud Tthonnart
Date:
Subject: How to create a dynamic list?
Next
From: Tom Lane
Date:
Subject: Re: UNIQUE constraint fails