sequence problem - many rows
От | Sterpu Victor |
---|---|
Тема | sequence problem - many rows |
Дата | |
Msg-id | 438C7B20.2090607@ambra.ro обсуждение исходный текст |
Ответы |
Re: sequence problem - many rows
|
Список | 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 по дате отправления: