UNIQUE constraint fails

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

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

But I didn't ask that "login" be a PRIMARY KEY, only a UNIQUE. What's
going on there?

Cheers,

--
ARICIE: Vous laissez dans l'erreur un pre qui vous aime ?
Cruel, si de mes pleurs mprisant le pouvoir,
Vous consentez sans peine ne plus me revoir,
Partez, sparez-vous de la triste Aricie.
(Phdre, J-B Racine, acte 5, scne 1)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Renaud Tthonnart 2001-02-23 09:40:30 Re: Query with multiples operators BETWEEN
Previous Message Boszormenyi Zoltan 2001-02-23 09:15:59 Re: how critical is WAL