Re: What constitutes a pgsql session?

From: Andrew Kelly <akelly(at)transparency(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Taber, Mark" <Mark(dot)Taber(at)dof(dot)ca(dot)gov>, pgsql-novice(at)postgresql(dot)org
Subject: Re: What constitutes a pgsql session?
Date: 2004-08-11 10:22:52
Message-ID: 1092219772.10078.18.camel@hermes.at.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, 2004-08-11 at 03:44, Bruce Momjian wrote:
> Taber, Mark wrote:
> > We have a need to create temporary tables (within functions); the
> > documentation states that temporary tables last as long as the pg session.
> > What, precisely, does this mean? The length of the active connection?
>
> Yes, a session is the client/server db connection. When you disconnect,
> the session is terminated.

What happens during connection pooling?
Would a temp table be global to everybody on the same connection?
Would the table remain after "my" disconnect, when others are still
connected via the shared session "I" was just using?

Andy

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2004-08-11 10:43:12 Re: Query result to a file
Previous Message Scott Marlowe 2004-08-11 09:19:11 Re: which version ?