Re: [Firebird-devel] Global Connection Context Variables?

[Dmitry Y. <di...@us...>]

"Nando Dessena" <na...@de...> wrote:
>
> Does a connection-level temporary table have to be created (with
> CREATE TABLE) by the application upon connection?

It has to be created once, as any other table, and its definition will be
preserved in the schema until it's dropped explicitly.

> If so, and assuming that we would like to allow access to temporary
> tables in triggers and stored procedures), does this mean that we will
> need the ability to compile a stored procedure that references a non
> existing table (which involves deferred compilation, a different
> dependency tracking scheme than what we have now, and possibly
> invalidation)?

SPs/triggers may reference temporary tables without any problems, because
their definition is static. Only their data depends on either connection or
transaction lifetime.


Dmitry