Subject Re: [firebird-support] Re: Backup & Restore NOT NULL Columns
Author Hugo Eyng
Hello Dimitry.

I thought I was testing in FB 3.0, but I wasn´t. I am sorry.

I tried FB 3.0 now and it really raises and error at step 1. Then I use DEFAULT clause and it works like I expected.

Thanks for your answer.


On 26/05/2015 03:08, Dmitry Yemanov dimitr@... [firebird-support] wrote:
25.05.2015 17:43, Hugo Eyng hugoeyng@... wrote:
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 tried to restore the backup file to a new MYDB.FDB and FB raises
and error: gbak: ERROR:validation error for column NAME, value "*** null

Let´s accept than the step 3 is coherent.

So, why can I execute step 1 without troubles?

I am using FB 2.5 and I tried using FB 3.0 too.
Did you really try FB 3.0? It should raise an error at step 1.





Visit and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at 


Yahoo Groups Links

<*> To visit your group on the web, go to:

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    (Yahoo! ID required)

<*> To change settings via email:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo Groups is subject to:



Hugo Eyng