sequence problem - many rows

From: Sterpu Victor <victor(at)ambra(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: sequence problem - many rows
Date: 2005-11-29 16:00:32
Message-ID: 438C7B20.2090607@ambra.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have the following table
Column | Type | Modifiers
----------------+-------+-----------------------------------------------------------------
id | integer | not null default
nextval('cachedgroupmembers_id_seq'::regclass)
groupid | integer |
memberid | integer |
via | integer |
immediatepar | integer |
disabled | integer | not null default 0
Indexes:
"cachedgroupmembers_pkey" PRIMARY KEY, btree (id)
"cachedgroupmembers2" btree (memberid)
"cachedgroupmembers3" btree (groupid)
"disgroumem" btree (groupid, memberid, disabled)

And the sequence for the id column:
CREATE SEQUENCE cachedgroupmembers_id_seq CACHE 1000;

Now the table is empty and I try to insert a row in this table:
INSERT INTO cachedgroupmembers(groupid) values(55);
And it works.

Next I populate the table wittt aprox 700.000 records.
And I do again "INSERT INTO cachedgroupmembers(groupid) values(55);".
The error is : ERROR: duplicate key violates unique constraint
"cachedgroupmembers_pkey"

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-11-29 16:04:52 Re: Question
Previous Message Florian Pflug 2005-11-29 14:26:02 Re: Strange VACUUM behaviour