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
>