From: | Sterpu Victor <victor(at)ambra(dot)ro> |
---|---|
To: | Sterpu Victor <victor(at)ambra(dot)ro>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: sequence problem - many rows |
Date: | 2005-11-29 16:09:07 |
Message-ID: | 438C7D23.8090406@ambra.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I shoul start the sequence with the last number in the higher number in
the table +1.
It works.
Sterpu Victor wrote:
> 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 | hubert depesz lubaczewski | 2005-11-29 16:58:45 | memory leak under heavy load? |
Previous Message | A. Kretschmer | 2005-11-29 16:06:58 | Re: Question |