pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSeparate Sessions?? (View data <-> Query tool)
3+ messages / 2 participants
[nested] [flat]
* Separate Sessions?? (View data <-> Query tool)
@ 2008-11-25 14:06 Csaba Együd <csegyud@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Csaba Együd @ 2008-11-25 14:06 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm administering a Pg8.3 database with PgAdmin3.
The users need views "pre" filtered on a session based vairable wich is
stored in a temporary table. Immediately after logging into the database the
client software creates a temporary table and stores an idin that. The users
query views when they want to see the contents of a filtered table and
modify the tables directly - which tables have BEFORE UPDATE/DELETE/INSERT
trigers to check the existence of the Temp table and to force filter field
values to be defaulted to the temporary table field. I hope it is clear...
:)
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 guess View data function establishes a separate connection to the database
to serve the query - or what??
How could I force PgAdmin3 to use the same session or how could I make the
table view to see the session wide temp table which was created earlier in a
query tool?
Many thanks,
--
Best Regards,
Csaba Együd
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Separate Sessions?? (View data <-> Query tool)
@ 2008-11-25 17:12 Scott Marlowe <scott.marlowe@gmail.com>
parent: Csaba Együd <csegyud@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Marlowe @ 2008-11-25 17:12 UTC (permalink / raw)
To: Csaba Együd <csegyud@gmail.com>; +Cc: pgsql-admin
2008/11/25 Csaba Együd <csegyud@gmail.com>:
> Hi,
> I'm administering a Pg8.3 database with PgAdmin3.
>
> The users need views "pre" filtered on a session based vairable wich is
> stored in a temporary table. Immediately after logging into the database the
> client software creates a temporary table and stores an idin that. The users
> query views when they want to see the contents of a filtered table and
> modify the tables directly - which tables have BEFORE UPDATE/DELETE/INSERT
> trigers to check the existence of the Temp table and to force filter field
> values to be defaulted to the temporary table field. I hope it is clear...
> :)
>
> 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Separate Sessions?? (View data <-> Query tool)
@ 2008-11-25 17:37 Csaba Együd <csegyud@gmail.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Csaba Együd @ 2008-11-25 17:37 UTC (permalink / raw)
To: pgadmin-support@postgresql.org.pgsql-admin
""Scott Marlowe"" <scott.marlowe@gmail.com> a következoket írta üzenetében
news:dcc563d10811250912h40956d32y6ba35fbf9ff75527@mail.gmail.com...
2008/11/25 Csaba Együd <csegyud@gmail.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@postgresql.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. My 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-11-25 17:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-11-25 14:06 Separate Sessions?? (View data <-> Query tool) Csaba Együd <csegyud@gmail.com>
2008-11-25 17:12 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-11-25 17:37 ` Csaba Együd <csegyud@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox