duplicate key violates unique constraint

Поиск
Список
Период
Сортировка
От vtaquette@globo.com
Тема duplicate key violates unique constraint
Дата
Msg-id 450D86C300003E02@mail03.sc2.he.tucows.com
обсуждение исходный текст
Ответы Re: duplicate key violates unique constraint  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-general
Hi,

I'm trying to create a table with a PRIMARY KEY. The CREATE statement looks
like this:

CREATE TABLE  "projects" (
  "project_id" serial,
  "username" varchar(30) NOT NULL default '',
  "project_name" varchar(30) NOT NULL default '',
  PRIMARY KEY  ("project_id")
) ;

The problem is that sometimes, I would say 1 in 10 tries, when I use a INSERT
command I get the following error:

"duplicate key violates unique constraint"

The INSERT query is that:
"INSERT INTO projects (\"project_name\", \"username\") VALUES ('$project_name',
'$username')";

Can someone help me please?!!

Thanks,
Verônica



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: server resetting
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: duplicate key violates unique constraint