Thread: Lifespan of temporary table

It is my understanding from the PG documentation that a temporary table
lasts until the end of the session.
When using jdbc, which one of
Connection con = DriverManager.getConnection(...)
or
PreparedStatement sql = con.prepareStatement(...)
actually opens a connection to the PG server?
What if I'm using poolmanager? When will the table be removed? (Because if
session==connection, con.close() in my servlet just returns the connection
to the pool, but the PG server sees the session still open.)
Thank you all.

Mihai,

Your assumption is correct, the temp table will not be removed until the
connection is really closed.

Dave
On Tue, 2002-08-06 at 13:54, Mihai Gheorghiu wrote:
> It is my understanding from the PG documentation that a temporary table
> lasts until the end of the session.
> When using jdbc, which one of
> Connection con = DriverManager.getConnection(...)
> or
> PreparedStatement sql = con.prepareStatement(...)
> actually opens a connection to the PG server?
> What if I'm using poolmanager? When will the table be removed? (Because if
> session==connection, con.close() in my servlet just returns the connection
> to the pool, but the PG server sees the session still open.)
> Thank you all.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>

Thank you very much.
So, if I want to save disk space on the PG server, I should execute a DROP
TABLE before closing the servlet connection to the poolmanager.
What method of PreparedStatement should I use: execute() or executeUpdate()?

>Mihai,
>
>Your assumption is correct, the temp table will not be removed until the
>connection is really closed.
>
>Dave
>On Tue, 2002-08-06 at 13:54, Mihai Gheorghiu wrote:
>> It is my understanding from the PG documentation that a temporary table
>> lasts until the end of the session.
>> When using jdbc, which one of
>> Connection con = DriverManager.getConnection(...)
>> or
>> PreparedStatement sql = con.prepareStatement(...)
>> actually opens a connection to the PG server?
>> What if I'm using poolmanager? When will the table be removed? (Because
if
>> session==connection, con.close() in my servlet just returns the
connection
>> to the pool, but the PG server sees the session still open.)
>> Thank you all.
TIP 4: Don't 'kill -9' the postmaster