Thank you Ann. Greetings.
Walter. On Sat, Jun 20, 2015 at 9:04 AM, Ann Harrison [email protected] [firebird-support] <[email protected]> wrote: > > > > > On Jun 19, 2015, at 3:32 PM, 'Walter R. Ojeda Valiente' > [email protected] [firebird-support] < > [email protected]> wrote: > > > > > > After a cycle backup/restore: the restored database will have all the > rows with the new domain? > > > > All columns with domain D_CURRENCY that were created with DECIMAL(9, 2) > now will be DECIMAL(18, 2) ? > > Yes. Gbak is really an unload/recreate/reload. A newly restored database > will have all records at the same format version. The format version number > is a single byte, so it's possible to exhaust the format version numbers by > altering a table repeatedly (that's a hedge because I don't remember if the > byte is treated as signed). A gbak backup/restore resets the format version > numbers. (Again, a hedge because it may be necessary for gbak to alter > tables when there are cross references, so the restore may not create > exclusively format version 1 records). > > Good luck, > > Ann > >
