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

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

From: Csaba Együd <csegyud(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Separate Sessions?? (View data <-> Query tool)
Date: 2008-11-25 18:14:47
Message-ID: gghfak$10kk$1@news.hub.org (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-general
""Scott Marlowe"" <scott(dot)marlowe(at)gmail(dot)com> a következoket írta üzenetében
news:dcc563d10811250912h40956d32y6ba35fbf9ff75527(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
2008/11/25 Csaba Együd <csegyud(at)gmail(dot)com>:
> When I log in with PgAdmin I have to create the temp table manually. It's
> ok, and if I use the query tool i cansee query the views after creating
> the
> temp table. But if I want to see the contents of a view in table view
> (View
> Data-View all rows), the views are empty indicating that it lacks of the
> temporary table. When I view directly the table (not the view) and try to
> edit a field the trigger refuses it because of the lack of temp table.

I'm guessing that you're creating tables like:

create temporary table blah blah blah

and can't see them from other connections?  That's normal.  If you
want to be able to see tables from multiple sessions you need to
create regular tables.

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

-------
Scott,
I'm afraid I posted my letter to the wrong list. I wanted to post to the
pgAdmin not "simply" admin. Sorry for confusion.

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.

I hope this message will now directed to the pgadmin.support list.

Thank you,
-- Csaba Együd


Responses

pgadmin-support by date

Next:From: Dave PageDate: 2008-11-25 20:05:10
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Previous:From: Csaba EgyüdDate: 2008-11-25 17:37:12
Subject: Re: Separate Sessions?? (View data <-> Query tool)

pgsql-general by date

Next:From: Tom LaneDate: 2008-11-25 18:47:09
Subject: Re: Cannot restore table using pg_restore
Previous:From: Bill ToddDate: 2008-11-25 17:46:48
Subject: Cannot restore table using pg_restore

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