Re: Changing the Primary Key Column

Rich,

As was mentioned by Brent, you may have to look to see what the named constraint is and use it. However, the issue originally was that you weren't using the correct command as you were altering the table, but not altering the column.

Although the PostgreSQL documentation varies between releases, the following appears to be more complete in it's explanations:

http://www.postgresql.org/docs/8.0/static/sql-altertable.html

Brian Kurle
President
Traveling bits, Inc.
Cell: 503 961-2489
Fax: 503 640-3814

On Feb 24, 2011, at 7:51 AM, Rich Shepard wrote:

> On Thu, 24 Feb 2011, Brian Kurle wrote:
>
>> # alter table water_well alter column sequence_no drop not null;
>
> Brian,
>
> nevada=# alter table water_well alter column sequence_no drop not null;
> ERROR: column "sequence_no" is in a primary key
>
>> http://www.java2s.com/Code/PostgreSQL/Constraints/ALTERTABLEemployeeALTERCOLUMNidDROPNOTNULL.htm
>
> The example above does not have the id column as primary key or any other
> constraint.
>
> Rich
>
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pdxpug
>