Skip site navigation (1) Skip section navigation (2)

Re: BUG #2975: UNIQUE INDEX doesn't work

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Steven <s(dot)lambert(at)madeware(dot)nl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2975: UNIQUE INDEX doesn't work
Date: 2007-02-08 16:57:19
Message-ID: 200702081657.l18GvJ118920@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Steven wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      2975
> Logged by:          Steven
> Email address:      s(dot)lambert(at)madeware(dot)nl
> PostgreSQL version: 8.1.4
> Operating system:   Windows Xp Sp2
> Description:        UNIQUE INDEX doesn't work
> Details: 
> 
> I have a unique index on a table, but it is still possible to insert a
> duplicated row, without any message what so ever.

Please show us a self-contained example.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-bugs by date

Next:From: Asif AliDate: 2007-02-08 20:00:32
Subject: Re: server crash: displaying sqlerrm in exception block
Previous:From: Bruce MomjianDate: 2007-02-08 16:56:50
Subject: Re: BUG #2974: broken CHECK constraint with varchar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group