Re: [BUGS] BUG #1860: Insert failed due to unique index

2005-09-04 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Viswanath Ramineni wrote: >> I have a table with a primary key on id (integer) column and a unique >> index on varchar(10) column. Insertion fails when the value of the >> unique column is substring of an existing value. For example, if I >> have a row

Re: [BUGS] BUG #1860: Insert failed due to unique index

2005-09-03 Thread Peter Eisentraut
Viswanath Ramineni wrote: > I have a table with a primary key on id (integer) column and a unique > index on varchar(10) column. Insertion fails when the value of the > unique column is substring of an existing value. For example, if I > have a row with the unique column value 'TEST1', it will not

[BUGS] BUG #1860: Insert failed due to unique index

2005-09-03 Thread Viswanath Ramineni
The following bug has been logged online: Bug reference: 1860 Logged by: Viswanath Ramineni Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Beta Operating system: Windows 2000 Professional Description:Insert failed due to unique index Details: I have a tabl