how come you can not alter a table and add a primary key after the
table has been created?
(or at least i can't seem to)
mydb=> alter table actions add primary key (action);
ERROR: ALTER TABLE / ADD CONSTRAINT is not implemented for that
constraint type.
any suggestions?