| 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: | Whole Thread | Raw Message | 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 |