You do have to commit, though, before you can proceed to alter something you
just added
Alan
-----Original Message-----
From: Scott Taylor [mailto:scott@...]
Sent: Friday, 23 August 2002 21:55
To: ib-support@yahoogroups.com
Subject: [ib-support] Adding Constraints


Hello,

Using Linux FirebirdSS T6.2.681, is it necessary to have exclusive access
to add constraints to a table?

I just created 3 tables, 2 master tables and one detail on a live
system. Then with WISQL and Linux version ISQL using this code:

ALTER TABLE T_SECTION
ADD CONSTRAINT MASTER_TTYPE
FOREIGN KEY ( SEC_TTYPE )
REFERENCES TRL_TYPE ( TTYPE ) /* this one */
ON UPDATE CASCADE
ON DELETE CASCADE
, ADD CONSTRAINT MASTER_SECID
FOREIGN KEY ( SEC_ID )
REFERENCES T_SEC_ID ( SECID )
ON UPDATE CASCADE
ON DELETE CASCADE

gave me the error: "table TRL_TYPE is in use", which is silly because I
just created those tables and nobody has the software that uses them
yet. The only way to get it through was to kill all applications
accessing
the gds, until I had the only connection.

I don't see anything in the docs about needing to have exclusive access to
the entire database in order to alter a table. Maybe I missed it. Any
ideas?

Cheers.

Scott.


Yahoo! Groups Sponsor
ADVERTISEMENT



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]