sequence problem - many rows - Mailing list pgsql-general

From Sterpu Victor
Subject sequence problem - many rows
Date
Msg-id 438C7B20.2090607@ambra.ro
Whole thread Raw
Responses Re: sequence problem - many rows  (Oliver Elphick <olly@lfix.co.uk>)
List 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.



pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Installation trouble - Solved (?)
Next
From: Tom Lane
Date:
Subject: Re: Installation trouble - Solved (?)