You can use SET REFERENTIAL_INTEGRITY {TRUE | FALSE} for this purpose.
Fred Toussi
----------------------------
scott wrote:
Looking in the docs and thru the mailing lists I don't see anything about
supporting this feature. Has there been any discussion about including it
in future releases?
Just to be clear, deferring constraint enforcement would allow me to do
the following:
Have tables A and B: both have a foreign key relationship to the other.
Both have foreign key constraints that relate to each other. Deferring
would allow me create both these records. Otherwise I wouldn't be able to
create either.
Searching thru the source for the word defer came across a couple of hits,
but from a quick glance they seem to be for support for the jdbc driver.
keep up the great work
scott
-------------------------------------------------------
This sf.net email is sponsored by: Influence the future
of Java(TM) technology. Join the Java Community
Process(SM) (JCP(SM)) program now.
http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0004en
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
