Thread: Does query window create a new connection?

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

Guy Rouillier wrote:
> 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?

Yes, it does.

//Magnus

> ------- Original Message -------
> From: Guy Rouillier <guyr-ml1@burntmail.com>
> To: PgAdmin Support <pgadmin-support@postgresql.org>
> Sent: 16/10/07, 19:04:26
> Subject: [pgadmin-support] Does query window create a new connection?
> 
> Does opening the query window create a new connection? 

Yes.

Regards, Dave