Subject | RE: [ib-support] Firebird : How to have a foreign key without an automatic created related index |
---|---|
Author | Helen Borrie |
Post date | 2001-08-29T13:39:18Z |
At 06:27 PM 29-08-01 +0400, you wrote:
Cheers,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>I'm confirming it with my Win32 1.0.0.338 beta 2 build:Thanks, Dmitry!
>
>alter table "Activities" add constraint fk_activities foreign key
>("Company") references "Agents" ("Id");
>commit;
>
>then
>
>alter index rdb$foreign64 inactive;
>
>=>
>
>This operation is not defined for system tables.
>unsuccessful metadata update.
>MODIFY RDB$INDICESS failed.
>action cancelled by trigger (3) to preserve data integrity.
>Cannot deactivate primary index.
>
>Dmitry
Cheers,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________