Re: temporary tables

From: Richard Huxton <dev(at)archonet(dot)com>
To: Orhan <orhan(at)cmu(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: temporary tables
Date: 2005-11-09 14:54:17
Message-ID: 43720D99.60705@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2005-11-09 14:57:43 Re: How to obtain the code af a function ?
Previous Message Richard Huxton 2005-11-09 14:53:40 Re: Postmaster failing to start on reboot