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 11:25:21
Message-ID: ggjbn0$30tf$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:937d27e10811260310y61b2c739kc2ff06ff86218e95(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
On Wed, Nov 26, 2008 at 10:17 AM, Csaba Együd <csegyud(at)gmail(dot)com> wrote:

> BTW, is it that weird way to define a session wide temp table storing some
> session specific information to generate e.g. views based on that? The 
> only
> thing I wanted to have a more comfortable tool to modify a few fields in 
> the
> table then having to compose SQL statements in the query tool. The problem
> is that my triggers refuse modifying a record if a given Temp table is not
> created before, because one or more fields have their default values from
> that temp table.

The does sound odd.

> I agree that running an SQL before viewing data in table view would be a 
> bit
> silly. But I could think something like a new per server connection 
> property
> in which I could define a single SQL sentence which would be automatically
> run after a connection is successfully established. It could be like modem
> initialization commands or something like that. Of course it could be 
> empty
> by default...

One of the problems is that pgAdmin sets up connections as it requires
to make things work correctly. Allowing arbitrary commands to be run
could easily break that - for example; if you changed the client
encoding. Additionally, it's not always obvious what connection will
be used unless you're pretty familiar with the way pgAdmin works
internally.



-- 
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


Unfortunately I'm not familiar with pgAdmin's internal connection handling. 
So I will live with query tool.
Thank you for your assistance and also for this great tool.

-- Csaba 


In response to

Responses

pgadmin-support by date

Next:From: Willy-Bas LoosDate: 2008-11-27 08:36:36
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Previous:From: Dave PageDate: 2008-11-26 11:10:06
Subject: Re: Separate Sessions?? (View data <-> Query tool)

pgsql-general by date

Next:From: Alvaro HerreraDate: 2008-11-26 12:30:47
Subject: Re: Effect of stopped status collector process
Previous:From: Dave PageDate: 2008-11-26 11:10:06
Subject: Re: Separate Sessions?? (View data <-> Query tool)

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