Maybe add and maintain a CURRENT_CONNECTION field to the TEMP table, to
differentiate between the
connection 'user' entries. Else port the TEMP table to a local table.

--------------------------------------------------------------------------------------------------------------

----- Original Message -----
From: <Hemant.Sapre@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, November 28, 2005 10:41 PM
Subject: [firebird-support] GLOBAL TEMPORARY tables in Firebird


> Hi,
>
>
>
> Does Firebird have GLOBAL TEMPORARY table concept. We are facing
> problems in a multiple user environment where users are writing to a
> single table concurrently. The page is locked due to Lock contention.
> Can this problem be overcome by any other means?
>
>
>
> Thanks and Regards,
>
> Hemant.
>
> Project Leader - Investment Banking Group
>
> PrimeSourcing(tm) "Add Value Reduce Risk"
>
> i-flex solutions ltd., Mumbai
>
> Tel Office: +91-22-5642-7144
>
> e-mail: hemant.sapre@...
> <mailto:hemant.sapre@...>
>
>
>
>
>
> DISCLAIMER:
> This message contains privileged and confidential information and is
> intended only for the individual named.If you are not the intended
> recipient you should not disseminate,distribute,store,print, copy or
> deliver this message.Please notify the sender immediately by e-mail if you
> have received this e-mail by mistake and delete this e-mail from your
> system.E-mail transmission cannot be guaranteed to be secure or error-free
> as information could be intercepted,corrupted,lost,destroyed,arrive late
> or incomplete or contain viruses.The sender therefore does not accept
> liability for any errors or omissions in the contents of this message
> which arise as a result of e-mail transmission. If verification is
> required please request a hard-copy version.
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>