Re: adding a primary key column to a temporary table fails - Mailing list pgsql-bugs

> 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.