Hi Alex,
It seems the problem is only with the beta version
of FB, for the FB1-RC1 it is creating the FK. Actually
I was working on W2K and I have a RH 7.1 Linux installation, I tried to create in on that machine and
it worked.

I recently started working on FB, previously I was working on Sybase and Postgres. This FB did not support
deferrable FK? Any idea?

Thanks for your reply

Sudheer



On Fri, 23 Nov 2001 Alexander V.Nevsky wrote :

> --- In ib-support@y..., Sudheer Palaparambil
> <p_sudheers@y...> wrote:
> > Hi,
> >
> > What does the following error means ? This happened
> > when I tried to create a foreign key on table batch
> > (both tables are empty now )
> > ALTER TABLE batch ADD FOREIGN KEY (PRODUCT_ID)
> > REFERENCES PRODUCT(ID);
>
> Hi, Sudheer. We are colleagues on this misfortune,
> see my post
> "RDB$INDEX_16 ...". What build are you using? I
> encounter this and
> other problems on LI-T1.0.0.368 when change metadata
> being not the
> single connected to database. About this concrete case
> - records in
> RDB$FORMATS about one of this tables (in my case BATCH)
> or index
> RDB$INDEX_16 UNIQUE INDEX ON
> RDB$FORMATS(RDB$RELATION_ID, RDB$FORMAT)
> are corrupted. Since your tables are empty (I'm not so
> lucky), try to
> drop them and create once more being the only one
> connected. Let me
> know result, please, I'm not shure we can drop damaged
> table and I'm
> interested in it too.
>
> Best regards.
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Universal Inkjet Refill Kit $29.95
> Refill any ink cartridge for less!
> Includes black and color ink.
> http://us.click.yahoo.com/ltH6zA/MkNDAA/ySSFAA/dpFolB/TM
> ---------------------------------------------------------
> -------------~->
>
> 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/
>
>