In most cases you can insert into self referencing tables without turning
referential integrity off. These tables usually represent tree structures
and you begin by inserting the root node then work through the branches.
We have no plans for developing support for delayed referential integrity
checks. If you would you like to help develop this feature please say so.
Fred Toussi
--------------------------
scott wrote:
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
-------------------------------------------------------
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
