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

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

From: Csaba Együd <csegyud(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Date: 2008-11-26 05:37:30
Message-ID: gginar$137g$1@news.hub.org (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-general
""Dave Page"" <dpage(at)pgadmin(dot)org> a következoket írta üzenetében 
news:937d27e10811251205k65418b5esc9398343aea59ffb(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
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:   http://www.enterprisedb.com

-- 
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


Hi Dave,

so you say I have no chance to use a session wide temp table from triggers 
because I can not create it before viewing data?
Isn't there a way to run something before starting querying the data for 
table view? Imean it would be nice to be able to run a stored proc or any 
valid SQL statement in the session of View Data tool. If there is not, 
wouldn't it be good idea? It has minimal overhead and I think many people 
use temporary tables or have other depenencies influencing a given query.
Hoping... :) Thank you.

-- 
Best Regards,
Csaba Együd


In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2008-11-26 08:47:25
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Previous:From: Dave PageDate: 2008-11-25 20:05:10
Subject: Re: Separate Sessions?? (View data <-> Query tool)

pgsql-general by date

Next:From: Scott MarloweDate: 2008-11-26 06:20:56
Subject: Re: Postgres 8.3 only uses seq scan
Previous:From: Clemens SchwaighoferDate: 2008-11-26 05:22:29
Subject: Re: Postgres 8.3 only uses seq scan

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