Re: temporary tables - Mailing list pgsql-general

From Richard Huxton
Subject Re: temporary tables
Date
Msg-id 43720D99.60705@archonet.com
Whole thread Raw
In response to temporary tables  ("Orhan" <orhan@cmu.edu>)
List pgsql-general
Orhan wrote:
> The PostgreSQL docs say that "Temporary tables are automatically
> dropped at the end of a session, or optionally at the end of the
> current transaction." If I create a temporary table through a
> java.sql.Statement and then call close() on that Statement, will the
> temporary table be dropped? In other words, does a java.sql.Statement
> carry its own "session"?

A session is from connection to disconnect.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: newbie design question re impact of VACUUM
Next
From: Csaba Nagy
Date:
Subject: Re: Question on Insert / Update