Skip site navigation (1) Skip section navigation (2)

Re: Does query window create a new connection?

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
Cc: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Does query window create a new connection?
Date: 2007-10-16 18:07:36
Message-ID: 4714FDE8.2060600@hagander.net (view raw or flat)
Thread:
Lists: pgadmin-support
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

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2007-10-16 18:20:18
Subject: Re: Does query window create a new connection?
Previous:From: Guy RouillierDate: 2007-10-16 18:04:26
Subject: Does query window create a new connection?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group