Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: 8.1 Unique Index Issue/Bug???
- From: Peter Eisentraut <peter_e(at)gmx(dot)net>
- To: pgsql-admin(at)postgresql(dot)org
- Cc: "Chris Hoover" <revoohc(at)gmail(dot)com>
- Subject: Re: 8.1 Unique Index Issue/Bug???
- Date: Thu, 13 Jul 2006 17:55:26 +0200
Am Donnerstag, 13. Juli 2006 16:40 schrieb Chris Hoover: > On this table, I have created a unique index on payer_trn03, payer_trn04, > and expire_timestamp. However, since the expire_timestamp is normally > null, the unique index does not appear to be working. I have been able to > enter two identical rows into this table. This behavior is correct according to the SQL standard, as two null values are not considered equal. -- Peter Eisentraut http://developer.postgresql.org/~petere/
- References:
- 8.1 Unique Index Issue/Bug???
- From: Chris Hoover
- 8.1 Unique Index Issue/Bug???
- Prev by Date: Re: 8.1 Unique Index Issue/Bug???
- Next by Date: Re: 8.1 Unique Index Issue/Bug???
- Previous by thread: Re: 8.1 Unique Index Issue/Bug???
- Next by thread: Re: 8.1 Unique Index Issue/Bug???
- Indexes: