Re: BUG #1860: Insert failed due to unique index

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 allow me
> insert another row with 'TEST' as the value for this column.

Please show the exact sequence of commands that leads to this situation.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/