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
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