Duplicate records in table

From: "Vinod Viswanathan" <vinodv(at)optena(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Duplicate records in table
Date: 2005-04-09 00:40:32
Message-ID: 05425E6D6FB8E247BE7656DCA211DC3D0765D770@ex7.hostedexchange.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-04-09 01:10:53 Re: [HACKERS] plPHP in core?
Previous Message Tom Lane 2005-04-08 21:34:41 Re: Can't install plpython on Windows 8.0