Subject RE: [firebird-support] default field value retrospective behaviour
Author Nigel Weeks
> Yes. Adding a column doesn't do anything to the data in
> existing rows; so setting a default for it doesn't magically
> fill it with the default value, either. Furthermore, you can
> add a column with a NOT NULL constraint on it and immediately
> make your database unrestorable if you don't go in and
> populate your existing rows.

Now that is a great pearl of wisdom. Awesome!

I know you don't eat chocolate, but next time you're in Tassie, I'll buy you
some sort of tasty treat!

Nige.