Re: adding a primary key column to a temporary table fails

From: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: adding a primary key column to a temporary table fails
Date: 2004-07-22 14:18:31
Message-ID: 200407221618.31906.ftm.van.vugt@foxi.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Luke McFarlane 2004-07-23 05:49:30 Re: ecpg -D SYMBOL
Previous Message Stephan Szabo 2004-07-22 14:01:03 Re: adding a primary key column to a temporary table fails