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.
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 |