From: | "Mihai Barbos" <barbos(at)moon(dot)ro> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-sql(at)hub(dot)org> |
Subject: | Re: [SQL] UNIQUE constraint |
Date: | 1999-08-21 15:01:02 |
Message-ID: | 000201beed47$f7dbf140$4a8823d4@gigell |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
My fault, the correct situation is
create table TEST (
testkey something PRIMARY KEY,
testval something UNIQUE,
.....................
);
PRIMARY KEY works OK, but UNIQUE is ignored.
-----Original Message-----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mihai Barbos <barbos(at)moon(dot)ro>
Cc: pgsql-sql(at)hub(dot)org <pgsql-sql(at)hub(dot)org>
Date: Thursday, August 12, 1999 4:25 PM
Subject: Re: [SQL] UNIQUE constraint
>"Mihai Barbos" <barbos(at)moon(dot)ro> writes:
>> Maybe I haven't looked in the roght place but here's my problem:
>> I've upgraded to 6.5 and I'm trying to use UNIQUE, something like:
>> create table TEST (
>> testval something UNIQUE,
>> .....................,
>> );
>> In 6.4.2 it worked OK, but now it seems it has no effect. Is there any
>> problem with UNIQUE ?
>
>I don't see any:
>
>create table TEST (
>testval int4 UNIQUE
>);
>NOTICE: CREATE TABLE/UNIQUE will create implicit index 'test_testval_key'
for table 'test'
>CREATE
>insert into test values (1);
>INSERT 283276 1
>insert into test values (1);
>ERROR: Cannot insert a duplicate key into a unique index
>
>You're going to have to be more specific about what problem you
>are observing.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1999-08-22 12:22:39 | Re: [SQL] What JDBC datatype can be used for DATETIME ? |
Previous Message | Eric Enockson | 1999-08-21 10:17:16 | can i send without being a member |