Subject Re: [firebird-support] multi connection Meta data update
Author Helen Borrie
At 05:12 AM 30/08/2004 -0700, you wrote:
>Dear Team ,
> I opened two isql.exe prompt (let us assume name
>'one' and 'two' repectively for those prompts.). Then
>via 'One' I created a Table 'A'. Then in same prompt
>'one', I created table 'B' with FK to Table 'A'. But
>it has thrown meta data error.

Correct. You need exclusive access to create foreign keys, as I think
Martijn has told you twice in this thread.

> Since in prompt 'two' I don't have did any operation
>pertaining to table 'A' or 'B'. (not even select
>query) I thought there is no 'interseting' tansaction
>related to object of 'A' or 'B' , I expected there
>won't be any error. But I got a meta data error in
>prompt 'one'. When I exit prompt 'two' (i.e. when i
>used only one connection via prompt 'one'). Table B
>has got created sucessfully.
> So I hope there is no relation to jay bird in this

No, it's the rule for foreign keys. And you should make it a rule for any
metadata changes...