Well I could turn off referential integrity, but this would defeat the
whole purpose of having it. I'm looking more for when you are creating
multiple records not having the constraint error get triggered (yes that
is a bad word to use when discussing a DB :) ) until the transaction is
committed. In Oracle this is something that is defined on the constraint.
scott
----------------------------------------------------------
From: fredt <[EMAIL PROTECTED]>
Re: defer constraint enforcement
2002-10-31 13:52
You can use SET REFERENTIAL_INTEGRITY {TRUE | FALSE} for this purpose.
Fred Toussi
A
On Thu, 31 Oct 2002, 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
>
>
>
>
--
"After sixteen years, MTV has finally completed its deevolution into the
shiny things network."
-The Onion
-------------------------------------------------------
This SF.net email is sponsored by: ApacheCon, November 18-21 in
Las Vegas (supported by COMDEX), the only Apache event to be
fully supported by the ASF. http://www.apachecon.com
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
