BUG with UNIQUE clause

From: Stéphane FILLON <fillons(at)offratel(dot)nc>
To: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: BUG with UNIQUE clause
Date: 1999-09-14 18:14:15
Message-ID: 000f01befedd$3f26fda0$a6373ad1@portable
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

Hi,

The UNIQUE constraint doesn't work on a field if I use a DEFAULT clause on a table.

The following table works with UNIQUE constraint:

create table cltclt001(
tcid int2,
tcnom text unique
);

but this one accept several same tcnom value:

create table cltclt001(
tcid int2 default nextval('cltcls001'),
tcnom text unique
);

What's wrong with my table ?

Thanks in advance.

Stephane FILLON

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aaron J. Seigo 1999-09-14 18:22:15 Re: [GENERAL] max() question
Previous Message Stéphane FILLON 1999-09-14 16:50:09 Permission problem with COPY FROM

Browse pgsql-hackers by date

  From Date Subject
Next Message Ryan Kirkpatrick 1999-09-14 21:44:30 Re: [HACKERS] Re: HISTORY for 6.5.2
Previous Message Theo Kramer 1999-09-14 17:08:51 Re: [HACKERS] ISO dates with European Format

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Meskes 1999-09-14 18:23:04 Re: [INTERFACES] ecpg and getting just assigned serial number
Previous Message Peter Mount 1999-09-14 17:33:16 Re: [INTERFACES] JDBC and getting just assigned serial number