Home > mailing lists

Duplicate records in table - Mailing list pgsql-general

From	Vinod Viswanathan
Subject	Duplicate records in table
Date	April 11, 2005 01:03:52
Msg-id	05425E6D6FB8E247BE7656DCA211DC3D0765D770@ex7.hostedexchange.local Whole thread Raw
Responses	Re: Duplicate records in table (John Burger <john@mitre.org>)
List	pgsql-general

I have a table with an btree unique index over 4 varchar keys.

When I insert and if one or more keys is null, postgres allows duplicate rows to be inserted into the table.

Are there some issues if index keys are null.

Thanks

Vinod Viswanathan

pgsql-general by date:

From: fritz-bayer@web.de (Fritz Bayer)
Date: 11 April 2005, 01:03:48
Subject: Encoding Issue with UNICODE

From: Chris Smith
Date: 11 April 2005, 01:03:54
Subject: using limit with delete