> What happens is the sequence is shared between several tables (eg. invoice > numbers or something) You cannot accomplish this situation by strictly using the SERIAL type.
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных