On Tue, 21 Jan 2003, Ali Young wrote: > On Tue, 21 Jan 2003, Raf wrote: > This should work: > UPDATE pg_attribute SET attnotnull = FALSE > WHERE attname = 'my_column' > AND attrelid = ( SELECT oid FROM pg_class WHERE relname = 'my_table') ; >
If anyone is interested: Just discovered that pg_attribute.atttypmod can also be used to resize varchar lengths. From what I've read it appears to be a stable hack.