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/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
