Re: Lifespan of temporary table

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)
>
>