Re: [firebird-support] Backup Restore NOT NULL Columns

2015-05-26 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello Thomas. Please see my answer to Dimitry. Thanks for your answer. Hugo On 26/05/2015 02:53, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: Hugo, Hello. 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There

Re: [firebird-support] Backup Restore NOT NULL Columns

2015-05-26 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello Thomas. I saw Dimtry´s comment. About the DEFAULT CLAUSE, even provided, it acts only on new rows and not on preexisting rows. Is this true? Hugo On 26/05/2015 02:53, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: Hugo, Hello. 1 - I created a column NOT

[firebird-support] Backup Restore NOT NULL Columns

2015-05-25 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello. 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There were already some records in the table. FB didn´t raise any warning or exception. 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise any warning or exception. 3- I

Re: [firebird-support] Backup Restore NOT NULL Columns

2015-05-25 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hugo, Hello. 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There were already some records in the table. FB didn´t raise any warning or exception. 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise any warning or