Skip site navigation (1) Skip section navigation (2)

Insert failure on serial

From: "Warren Seltzer" <warrens(at)actcom(dot)net(dot)il>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Insert failure on serial
Date: 2006-05-03 14:18:01
Message-ID: 002301c66ebc$67b26790$23cd19ac@Whatever (view raw or flat)
Thread:
Lists: pgsql-bugs
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 "line_items_pkey"
 
See attached file for more info. Bugreport.txt is psql narrative.  Dumpdd.sql is the dump
of entire (tiny) database, without the offending insert.
 
Thanks in Advance
 
Warren Seltzer
 

Attachment: dumpdd.sql
Description: text/plain (7.2 KB)
Attachment: bugreport.txt
Description: text/plain (2.4 KB)

Responses

pgsql-bugs by date

Next:From: Simon BurgeDate: 2006-05-04 06:49:54
Subject: BUG #2420: NetBSD doesn't need float8-small-is-zero regression test resultmap entry
Previous:From: Andy MaleDate: 2006-05-03 08:41:41
Subject: BUG #2419: could not reattach to shared memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group