""Dave Page"" <[EMAIL PROTECTED]> a következoket írta üzenetében
news:[EMAIL PROTECTED]
2008/11/25 Csaba Együd <[EMAIL PROTECTED]>:
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@postgresql.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
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
