Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: resetting sequence to cur max value
Date
Msg-id 4919.1165943996@sss.pgh.pa.us
Whole thread Raw
In response to resetting sequence to cur max value  (developer@wexwarez.com)
Responses Re: resetting sequence to cur max value  (developer@wexwarez.com)
Re: resetting sequence to cur max value  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
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: Richard Huxton
Date:
Subject: Re: date comparisons
Next
From: developer@wexwarez.com
Date:
Subject: Re: resetting sequence to cur max value