>>It doesn't sound right. If you included DEFAULT for new column it should be used. Double check that you specified it correctly.
>
>DEFAULT only takes it from now on. It doesn't affect existing data. It required the use of WITH VALUES. This has resolved the issue.
Only if column has NULL attribute. If you create it as NOT NULL, default values will be used for all rows.
--sb--