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