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
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 |
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 |
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 |