Re: Changing the Primary Key Column

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