On Mon, 2005-06-20 at 10:20, Anjan Dave wrote:
> Hi,
>
>
>
> A developer is trying to use a Temporary Table via the java based
> application. The problem is following the temp table creation, he
> wants subsequent queries to query the temp table, but they are not in
> the same database session as the temp table. Is this something I can
> setup somewhere in the config? I would appreciate any pointers/info I
> can forward to him.
His usage suggests he should be using a regular table, possibly with
some kind of clean up / setup user defined functions associated with it.
The whole idea of temporary tables is that they allow you to write a
single client that declares a single table by name, and then you can run
that client any number of times, and each will not interfere with the
other. Generally, trying to share temp tables across different backends
is a bad idea, since the original session that created it might exit and
it would cease to be.