Subject Re[2]: [ib-support] Firebird : How to have a foreign key without an automatic created related index
Author Carlos H. Cantu
Helen,

In true that was a question sent by an user of my mailing list. He said
that he tried to disable the index but he wasnt able do that. I will try it by
myself as soon as I have time to...

Thanks.

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com

HB> At 08:45 PM 28-08-01 -0300, you wrote:
>>It says that it is already implemented but how to do that ?

HB> AFFAIK, the auto index will still be created. The change (I believe) is that you will be able to disable the index (= set inactive).

HB> Where does "it" say that it is already implemented? I thought it was still in testing...

HB> You could test whether it's implemented by searching for the name of the index (or look it up in IB_SQL) and trying to set it inactive...as I don't use foreign keys at all, I'd appreciate your
HB> posting back (I'm writing the release notes).

HB> Cheers,
HB> Helen



>>[]s
>>
>> Carlos
>> WarmBoot Informatica - http://www.warmboot.com.br
>> Interbase-BR - http://www.interbase-br.com
>>
>>
>>
>>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/

HB> All for Open and Open for All
HB> InterBase Developer Initiative ยท http://www.interbase2000.org
HB> _______________________________________________________


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



HB> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/