Re: Changing the Primary Key Column

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Changing the Primary Key Column
Date: 2011-02-24 01:09:29
Message-ID: alpine.LNX.2.00.1102231708000.17955@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On Wed, 23 Feb 2011, Joshua D. Drake wrote:

> alter table drop constraint
> alter table drop column
> alter table add primary key
>
> done

Thanks, Josh.

When I do this and follow with '\d water_well' I still see the first
column (sequence_no) with the not null constraint. Wonder why that didn't
drop when I specified the column name in the drop column command.

Rich

In response to

Responses

Browse pdxpug by date

  From Date Subject
Next Message Michael Ewan 2011-02-24 01:11:40 Re: Changing the Primary Key Column
Previous Message Joshua D. Drake 2011-02-24 01:01:57 Re: Changing the Primary Key Column