Re: resetting sequence to cur max value - Mailing list pgsql-general

From developer@wexwarez.com
Subject Re: resetting sequence to cur max value
Date
Msg-id 4135.192.168.1.235.1165944161.squirrel@mail.wexwarez.com
Whole thread Raw
In response to Re: resetting sequence to cur max value  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Awesome.  Thanks tom.

By the way I am still trying to find a yum install for 8.2 for
centos...anyone?

> developer@wexwarez.com writes:
>> Is there a way to set it up so it knows to skip past existing ids?
>
> Usually you do something like
>
>     select setval('seq_name', (select max(idcol) from table) + 1);
>
> after loading data into the table.
>
>             regards, tom lane
>



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: resetting sequence to cur max value
Next
From: Bruce Momjian
Date:
Subject: Re: Restore database from files (not dump files)?