UCDI FAQ (в здешний FAQ еще не попало).

Q.>Как установить serial в нужное значение?
A.>Jonathan Leffler
To change the next inserted serial number to a value greater than its
current value you can:

ALTER TABLE...MODIFY( ser_col_name SERIAL([new_start_number])

To change the next inserted serial number to a value LESS than its
current value you need to first reset the
serial number to 1:

INSERT INTO table (serial_column) VALUES (2147483647);
INSERT INTO table (serial_column) VALUES (0); -- Back to 1 again!

...then perform an ALTER TABLE (as described above).


P.S. В случае с Serial8 "2147483647" будем другим :-).-----