Does query window create a new connection?

Поиск
Список
Период
Сортировка
От Guy Rouillier
Тема Does query window create a new connection?
Дата
Msg-id 4714FD2A.8000708@burntmail.com
обсуждение исходный текст
Ответы Re: Does query window create a new connection?  (Magnus Hagander <magnus@hagander.net>)
Список pgadmin-support
My development environment is PostgreSQL 8.2.0 on Windows.  I've just 
started exploring the use of SET and SHOW to store variables that I 
define via the custom class feature in postgresql.conf.  The default 
scope for these variables is session, according to the documentation. 
If I open a query window in PgAdmin 1.8.0 beta 3 and create a variable 
using SET, I can then use SHOW to display it.  However, if I close that 
query window and then open a new one, the variable appears to no longer 
be set.  Executing SHOW again produces an empty result.

Does opening the query window create a new connection?  I wouldn't think 
so.  But if not, then why aren't the session-scoped variables retaining 
their values?

Thanks.

-- 
Guy Rouillier


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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: pgAdmin 1.8RC1 - failed to launch on Mac OS X
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Does query window create a new connection?