Dear Ann W. Harrison ,

Thanks for your reply.

From your reply I understood that exclusive
connection check is not needed for super server. Even
our application need FireBird server in SUPERSERVER.


So do I modify the code such that exclusive connection
check is made only in classic server by including
preprocessor like below.

#ifdef SUPERSERVER
<don get exclusive connection>
#else
<check for exclusive connection else throw error as
in original case>.
#endif

And could you include the modification in firebird
distribution. So that all users of firebird can make
FK in multi connection with super server.


Thanks & Regards,
S.Karthick


--- "Ann W. Harrison" <aharrison@...> wrote:

>
> At 06:31 AM 9/27/2004, karthick srini wrote:
>
> > Let me know what is the
> >significance in getting exclusive connection for
> >foreign key based index alone.
>
> Because as soon as you commit that definition, all
> other users must immediately begin to check the
> constraint
> and return errors (or cascade, or whatever) if their
> operations would violate it. This is not a problem
> in
> superserver, because it keeps a single copy of the
> metadata
> and can adapt to changes. In classic mode, each
> user has
> its own copy of the metadata and must be notified.
> Your
> change does not include a notification to other
> Classic
> connections and will result in errors in that mode.
>
> Regards,
>
>
> Ann
>
>
>
>
>
> Yahoo! Groups Links
>
> http://groups.yahoo.com/group/Firebird-Architect/
>
> Firebird-Architect-unsubscribe@yahoogroups.com
>
>
>
>
>
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com