failed insert into serial-type row

From: "Hortschitz, Stefan" <Stefan(dot)Hortschitz(at)lfrz(dot)at>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: failed insert into serial-type row
Date: 2005-06-13 19:58:37
Message-ID: D12153701D57FF45A1AD64DFB6571D7C79DCCD@svie0107.vie01.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi,

i'm working with an postgresql-installation on Solaris ("PostgreSQL
7.4.7 on sparc-sun-solaris2.9, compiled by GCC 2.95.3") and I have the
following problem:

I'm using tables like this:
--------------------------------
CREATE TABLE session.preferences
(
id serial NOT NULL,
name varchar(50),
value varchar(255),
CONSTRAINT session_preferences_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE session.preferences OWNER TO web;
--------------------------------

and sometimes if i'm adding new rows to the table with statements like
this:
insert into (name,value) ('xy','xy');
the database only returns an 'duplicate key on primary key', which
should be prevented by the serial-datatype, or? how could it be, that
two rows become the same id??
if i execute the insert-statement again it works.

the created serial-sequence looks like this:
--------------------------------
CREATE SEQUENCE session.preferences_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 2487
CACHE 1;
ALTER TABLE session.preferences_id_seq OWNER TO web;
--------------------------------

what can I do against the duplicate-key problem? is it a configuration,
sql or operating-system specific problem?

with kind regards
stefan

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Hortschitz, Stefan 2005-06-14 05:28:22 failed insert into serial-type row
Previous Message Amir Becher 2005-06-13 16:44:30 Error Using CLUSTER