Subject Re: [ib-support] NOT NULL constraints and the System Tables
Author Ann W. Harrison
At 08:32 PM 11/13/2001 +0100, Martijn Tonies wrote:

>Good. Now, when I try to insert a NULL, it fails - even after committing.

Sigh. Looks as if someone needs to call MET_scan_relation.


>However, when I re-connect, everything is fine. It seems that upon
>connection (or so - can someone shed a light here?) this kind of meta-data
>is cached?

Yes.


>Next question: to do the reverse, is setting the RDB$NULL_FLAG to 1 enough
>to disallow NULLs?

I believe it is.



Ann
www.ibphoenix.com
We have answers.