Re: Cannot add non-null columns

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
>