Re: [GENERAL] resetting sequence to cur max value

[Tom Lane]

[EMAIL PROTECTED] 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match