On Tue, Jan 21, 2003 at 10:43:46AM +0000, Raf wrote: >borg=# ALTER TABLE my_table ALTER COLUMN my_column DROP NOT NULL; >ERROR: parser: parse error at or near "NOT" >Any ideas? Is it just restricted to dropping defaults?
I don't understand what you're trying to do. "DEFAULT" is a characteristic of a table column; it can be unset or have a value. Using ALTER TABLE, you can change the value of the DEFAULT. Roger
