pgsql-bugs(at)postgresql(dot)org writes:
> If you create a table with more than 1 SERIAL, only for the last a
> sequence is created by PostgreSQL. The other fields only set to
> INTEGER, but there is no sequence for.
This is fixed in 7.1.
regards, tom lane