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

Поиск

Список

Период

Сортировка

От	paul@entropia.co.uk
Тема	Re: Why am I getting the error: "Cannot insert a duplicate key into unique index"?
Дата	8 сентября 2004 г. 15:26:24
Msg-id	413F225E.17879.5E656F9@localhost обсуждение исходный текст
Ответ на	Why am I getting the error: "Cannot insert a duplicate key into unique index"? ("Daniel Secomb" <dan@ds-d.com>)
Список	pgsql-novice

You are trying to insert a value into a column that is declared as unique,

this value must already be in the column so pg rejects it.

> 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","date","uid","sub_t

> ype1","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

В списке pgsql-novice по дате отправления: