Why am I getting the error: "Cannot insert a duplicate key into unique index"?

From: "Daniel Secomb" <dan(at)ds-d(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Why am I getting the error: "Cannot insert a duplicate key into unique index"?
Date: 2004-09-08 13:48:05
Message-ID: MCBBIFBENOMGNJNDAAJBMECLCIAA.dan@ds-d.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and I'm getting the following
error when I try and run a SQL query on a script:

Error -
/usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php --
Line: 33
PostgreSQL said: ERROR: Cannot insert a duplicate key into unique index
inventory_pkey
Your query:
INSERT INTO "inventory"
("code","quantity","id","description","price","category","image","file","dat
e","uid","sub_type1","sub_type2","sub_type3","title","gst","gauge") VALUES
('1123',NULL,17,'Not really sure what to put in here But I am sure i will
told
:)','17.30',1,NULL,NULL,'2001-01-17',1,'Beans\015\012Means\015\012Hines','',
'','African Mist','0.00',7);

Any idea as to why this is doing this?

Thank you for your help.

Dan

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-09-08 14:08:19 Re: Problem executing user function (on Solaris)
Previous Message Daniel Secomb 2004-09-08 13:33:51 I NEED HELP!!! - (ERROR: parser: unterminated quoted string)