"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> You say:
> "All drop commands in PostgreSQL support specifying CASCADE. Of course"
> Which isn't technically true for the ALTER TABLE/DROP NOT NULL statement..
Come to think of it, that's probably a bug: you should not be able to
DROP NOT NULL on a column that's part of a PRIMARY KEY. Unless you
cascade to remove the primary key, that is.
regards, tom lane