Bug#442115: postgresql-8.1: can't insert value into unique field

2007-09-13 Thread Peter Eisentraut
Am Donnerstag, 13. September 2007 schrieb Moritz Lenz: > timtowtdi=> insert into users (username) values ('bar'); > ERROR: duplicate key violates unique constraint "users_pkey" > timtowtdi=> insert into users (username) values ('bar'); > INSERT 0 1 > > an insert into a column (here unsername) that

Bug#442115: postgresql-8.1: can't insert value into unique field

2007-09-13 Thread Moritz Lenz
Package: postgresql-8.1 Version: 8.1.9-0etch1 Severity: normal The following piece of a sql session it all: timtowtdi=> insert into users (username) values ('bar'); ERROR: duplicate key violates unique constraint "users_pkey" timtowtdi=> insert into users (username) values ('bar'); INSERT 0 1 a