i mean did you commit the transaction of the table creation before you added
the contraint?
-----Original Message-----
From: Scott Taylor [mailto:scott@...]
Sent: Friday, 23 August 2002 22:28
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Adding Constraints


At 05:21 AM 23/08/2002, you wrote:

>You do have to commit, though, before you can proceed to alter something

you

>just added

commit? If you mean complete the transaction, then yes, that's when the
error occurs if using WISQL's DSQL.

> 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]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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]