On Wed, Feb 14, 2007 at 10:01:58AM +0100, Steven Lambert wrote:
> You are right, the index has more columns and one of them have most of the
> time the value NULL.
> It is the date when the record has been "deleted"
See "Unique Constraints" in the documentation, in particular the
last paragraph:
On Thu, Feb 08, 2007 at 11:57:19AM -0500, Bruce Momjian wrote:
> Steven wrote:
> > 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.
Are you perchance inserting NULL into the co
Steven wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2975
> Logged by: Steven
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.1.4
> Operating system: Windows Xp Sp2
> Description:UNIQUE INDEX doesn't work
> Details:
>
> I have a
The following bug has been logged online:
Bug reference: 2975
Logged by: Steven
Email address: [EMAIL PROTECTED]
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 sti