On Tue, 2005-11-29 at 18:00 +0200, Sterpu Victor wrote:
> I have the following table
...
> 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) value
I have the following table
Column | Type |Modifiers
+---+-
id | integer | not null default
nextval('cachedgroupmembers_id_seq'::regclass)
groupid
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
+---+--
