Re: What constitutes a pgsql session?

Поиск
Список
Период
Сортировка
От Andrew Kelly
Тема Re: What constitutes a pgsql session?
Дата
Msg-id 1092219772.10078.18.camel@hermes.at.home
обсуждение исходный текст
Ответ на Re: What constitutes a pgsql session?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: What constitutes a pgsql session?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: which version ?
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: Query result to a file