Re: [BUGS] Insert failure on serial

2006-05-05 Thread Alvaro Herrera
Warren Seltzer wrote: > PostgreSQL 8.1.3 on i686-pc-mingw32 > Windows XP SP2 > > Summary of Insert failure (There IS NO DUPLICATE KEY): > depot_development=# INSERT INTO line_items ("order_id", "product_id", > "quantity", > "unit_price") VALUES(1, 2, 2, 989.99); > ERROR: duplicate key violates

[BUGS] Insert failure on serial

2006-05-05 Thread Warren Seltzer
Title: Message PostgreSQL 8.1.3 on i686-pc-mingw32 Windows XP SP2   Summary of Insert failure (There IS NO DUPLICATE KEY): depot_development=# INSERT INTO line_items ("order_id", "product_id", "quantity", "unit_price") VALUES(1, 2, 2, 989.99);ERROR:  duplicate key violates unique constraint