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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-10-16 18:20:18 | Re: Does query window create a new connection? |
Previous Message | Guy Rouillier | 2007-10-16 18:04:26 | Does query window create a new connection? |