| From: | Csaba Együd <csegyud(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Separate Sessions?? (View data <-> Query tool) |
| Date: | 2008-11-25 14:06:23 |
| Message-ID: | ggh0on$2167$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-11-25 17:12:55 | Re: Separate Sessions?? (View data <-> Query tool) |
| Previous Message | Stefan Keller | 2008-11-22 19:47:04 | How to view geometry fields as text? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-11-25 17:12:55 | Re: Separate Sessions?? (View data <-> Query tool) |
| Previous Message | Abdul Rahman | 2008-11-25 10:32:46 | Re: PgAgent Job Scehduler is NOT running |