With current sources,
regression=> create table xx (f1 int, f2 serial, f3 serial);
NOTICE: CREATE TABLE will create implicit sequence 'xx_f2_seq' for SERIAL column 'xx.f2'
NOTICE: CREATE TABLE will create implicit sequence 'xx_f3_seq' for SERIAL column 'xx.f3'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'xx_f2_key' for table 'xx'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'xx_f3_key' for table 'xx'
CREATE
regression=> insert into xx values(1);
ERROR: Relation 'xx_f2_seq' does not exist
regression=>
6.5.2 fails to do the CREATE TABLE at all. I'm betting this is related
to the multiple-unique-index bug that you thought you had fixed.
regards, tom lane