Hello,
if I'm not misteaken, it currently is not possible to have checking of
"NOT NULL" constraints be deferred to commit-time. It's possible to have
FK and unique constraints checking deferred, but not "NOT NULL" constraints.
"NOT NULL" constraints can result from primitive types being used, or an
explicit "allows-null" in a column tag. There should be some way to turn
these constraints into deferred constraints as well, IMHO, as any DDL
generated by the implementation needs to be modified by hand in order to
have them deferred.
Regards,
Jörg
--
__________________________________________________________
Dipl.-Inf. Jörg von Frantzius | artnology GmbH
| Milastr. 4
Tel +49 (0)30 4435 099 26 | 10437 Berlin
Fax +49 (0)30 4435 099 99 | http://www.artnology.com
_______________________________|__________________________