From: | "Gus List" <guslist(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | unique index |
Date: | 2006-02-27 21:11:07 |
Message-ID: | ac8725940602271311l13295ef9p29727b49e9cb0c98@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Greetings,
I have a very strange problem that I realy dont now if it should work this
way or if it is a bug or a enviroment problem.
I'm running postgres 8.1.0 on a 'White Box Enterprise release 4' Linux box.
I've created a unique constraint for multiple fields (3) with a condition.
Those fields are: bigint, varchar and varchar and the condition is status =
1 (status is a integer field) .
The condition works fine. It only lets me insert onde possible combination
and if the status condition complies.
The problem is that when I try to insert an duplicate entry for testing I
receive te error (ERROR: duplicate key violates unique constraint
"new_idx_UNIQ") but ALL RECORDS are DELETED. I don't think that this should
happen.
Can any one give me some help on that ?
Regards,
Gus
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-02-27 21:30:13 | Re: unique index |
Previous Message | kynn | 2006-02-27 19:10:10 | Re: How to enable remote anoymous logins? (+ admin books?) |