there was no existing data in the table, PK was the composite. I dropped the PK while doing the insert, then alter the table by adding the pk constraint - worked OK. Not sure, but maybe didn't like the select ??