> There are no trigger, it is checked by the corresponding index

I don't understand. There is a unique index on the parent's columns,
and a non-unique index on the child's columns. Something must run to
confirm that the value added/updated in the child exists in the parent's
index.

-----Original Message-----
From: Firebird-Java@yahoogroups.com
[mailto:Firebird-Java@yahoogroups.com] On Behalf Of Roman Rokytskyy
Sent: Friday, September 30, 2005 12:12 PM
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] How to turn referential integrity checking
off

> ALTER TABLE <table name> ALTER CONSTRAINT <foreign key name> INAVTIVE
> Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char
> 37 CONSTRAINT

Sure, this construct does not exist yet, but maybe Jim adds it in Vulcan
:)

> Although it might be implemented by turning off the trigger that
> enforces it.

There are no trigger, it is checked by the corresponding index... which
cannot be deactivated. So for now you can only drop constraint.





Yahoo! Groups Links