From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Anjan Dave <adave@vantage.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Temporary Tables
Date: Mon, 20 Jun 2005 11:03:49 -0500
Message-ID: <1119283429.3382.114.camel@state.g2switchworks.com> (raw)
In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78502EA14CB@vt-pe2550-001.vantage.vantage.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78502EA14CB@vt-pe2550-001.vantage.vantage.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@g2switchworks.com, adave@vantage.com
Subject: Re: Temporary Tables
In-Reply-To: <1119283429.3382.114.camel@state.g2switchworks.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78502EA14CB@vt-pe2550-001.vantage.vantage.com> <1119283429.3382.114.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox