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

Re: Separate Sessions?? (View data <-> Query tool)

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: Csaba Együd <csegyud(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Date: 2008-11-25 20:05:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-supportpgsql-general
2008/11/25 Csaba Együd <csegyud(at)gmail(dot)com>:

> Yes, I do use CREATE TEMPORARAY TABLE statement and I know that temp table
> lives only during the sessionor transaction. This is what I need.
> I meant that I'd like pgAdmin3 to use the same session both in the query
> tool and
> the view data tool to be able to use the temp table while modifying the data
> via view data tool.

That's simply not possible. It would blow up extremely quickly - as
soon as you set a GUC that the main browser wasn't expecting, or the
browser tried to run a query whilst you were (or vice-versa). You
could implement some kind of queuing mechanism of course, but that
would significantly reduce usability as everything would bottleneck
around a single connection.

Dave Page
EnterpriseDB UK:

In response to


pgadmin-support by date

Next:From: Csaba EgyüdDate: 2008-11-26 05:37:30
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Previous:From: Csaba EgyüdDate: 2008-11-25 18:14:47
Subject: Separate Sessions?? (View data <-> Query tool)

pgsql-general by date

Next:From: ChrisDate: 2008-11-25 22:29:22
Subject: Re: two or more pg installations running as the same user
Previous:From: Tom LaneDate: 2008-11-25 18:47:09
Subject: Re: Cannot restore table using pg_restore

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