> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html