hi!
afaik you cannot add a not null column to a table because (in a table where there is already some data) the field values are null. the option to add a not null column perhaps only works on an empty table with no rows yet. so this behaviour is expected.
therefore you need to add a column, update the table to set the column values so there is no null fields and then you can alter the column to set it a default value, then again to set it no null. this always worked for me.
hope it helps.
regards, Miha
teknokrat wrote:
If I go to a tables properties and try adding a non-null column I get an error. Adding the from the column view is OK.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
