> The issue here is the not-nullness of a new column which isn't supported
> in 7.4 (it appears to be in 7.5).
I grok.
> > By the way, I noticed that the todo-list does not mention 'alter table
> > alter column set/drop primary key'. I'm wondering whether it should?
>
> ALTER TABLE ADD CONSTRAINT can handle primary keys.
Now how did I miss *that* ;-\
> I think you probably want:
> alter table f_test add primary key (id);
Yep, that does the trick.
Thank!
--
Best,
Frank.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
