Re: [SQL] from not null field to nullable field?

Carolyn Lu Wong wrote: > > I have a field in a table that has been defined 'not null'. Is it > possible to remove this constraint? I don't see this option under 'alter > table'. update pg_attribute set attnotnull = 'f' where oid = oidofnotnullcolumn; vacuum analyze; Regards Wim

Re: [SQL] primary key question

Carolyn Lu Wong wrote: > > create table aaa( > field1 not null, > field2 , > , > primary key (field1, field2) > ); > > Based on the above table definition, field2 allows null values. But > after the table created based on the above script, field2 be