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" > borg=# > > > Any ideas? Is it just restricted to dropping defaults?
What are you trying to do? Delete rows where my_column IS NULL? Or delete columns where my_column IS NULL? I'm not sure if the second makes any sense, but I haven't had today's wake-up drink yet. As I understand it you can set the default value for a column, or drop the default value for a column. "DROP NOT NULL" doesn't seem like a sensible thing to try to do... Chisel -- e: [EMAIL PROTECTED] | Theoretically, if I were to know your w: www.herlpacker.co.uk | password, what would it be? gpg: D167E7FE |
