Thread: Separate Sessions?? (View data <-> Query tool)
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
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.
""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