Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2975: UNIQUE INDEX doesn't work - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #2975: UNIQUE INDEX doesn't work
Date
Msg-id 200702081657.l18GvJ118920@momjian.us
Whole thread Raw
In response to BUG #2975: UNIQUE INDEX doesn't work  ("Steven" <s.lambert@madeware.nl>)
Responses Re: BUG #2975: UNIQUE INDEX doesn't work  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Tree view 
Steven wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2975
> Logged by:          Steven
> Email address:      s.lambert@madeware.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@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #2974: broken CHECK constraint with varchar
Next
From: "Asif Ali"
Date:
Subject: Re: server crash: displaying sqlerrm in exception block