Does query window create a new connection?

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Does query window create a new connection?
Date: 2007-10-16 18:04:26
Message-ID: 4714FD2A.8000708@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Magnus Hagander 2007-10-16 18:07:36 Re: Does query window create a new connection?
Previous Message Dave Page 2007-10-16 14:06:35 Re: pgAdmin 1.8RC1 - failed to launch on Mac OS X