Subject | RE: [firebird-support] default field value retrospective behaviour |
---|---|
Author | Nigel Weeks |
Post date | 2005-08-19T06:56:24Z |
> Yes. Adding a column doesn't do anything to the data inNow that is a great pearl of wisdom. Awesome!
> 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.
I know you don't eat chocolate, but next time you're in Tassie, I'll buy you
some sort of tasty treat!
Nige.