Hi Dan,
Yes I have tried it after our chat. It seems cr_revisionsi works. But cr_fooi does not. After I manually recreated the table and removed the not null constraint it does go in. Put back the constraint it does not work, so it seem to boil down to the not null constraint.
I am using pg 7.2.1 in case pg changed the way they deal with constraints from 7.1.3
