Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1783F64FE23 for ; Tue, 25 Nov 2008 13:12:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 95292-04 for ; Tue, 25 Nov 2008 13:12:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.169]) by mail.postgresql.org (Postfix) with ESMTP id 3728F64FC83 for ; Tue, 25 Nov 2008 13:12:56 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 25so41435wfc.28 for ; Tue, 25 Nov 2008 09:12:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=eVSQbtwf/rg5Pkr60hKM2wJBmdOP/0aVjl4K7Uef4HU=; b=HtykOCBCjXJcVrX9CMldisy5025YiVMp0QwcD1reAcMKSmjuUuSe6ySi5HFgdB0ul6 /WUWFpMrZ+JGckzJkcXB+AKUT7uByzoOpsoI3MVjxFqySRt42AOm9/KP5KoTpypZXAdb ig7UYCy1aVi7hldei5CP8en/l83l6gSwzK1Cg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=KRskdbt0pAipz8l4iGTcouIzhYU6EzcJuVxyLzthOjBXq02w068RejRe2ReEbc00Wf +ivSr4+yCaUk7fbFRbqLzexSU/LNHmqObjn+07oQN57F83QdNLOQM+lDzzzuC82bX8D1 tgxNnwFoRflVaKC8HNj27DpRDSWFqYkrzZZN0= Received: by 10.114.148.2 with SMTP id v2mr2753167wad.169.1227633175267; Tue, 25 Nov 2008 09:12:55 -0800 (PST) Received: by 10.114.137.17 with HTTP; Tue, 25 Nov 2008 09:12:55 -0800 (PST) Message-ID: Date: Tue, 25 Nov 2008 10:12:55 -0700 From: "Scott Marlowe" To: "=?ISO-8859-1?Q?Csaba_Egy=FCd?=" Subject: Re: Separate Sessions?? (View data <-> Query tool) Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/143 X-Sequence-Number: 30797 2008/11/25 Csaba Egy=FCd : > 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 us= ers > query views when they want to see the contents of a filtered table and > modify the tables directly - which tables have BEFORE UPDATE/DELETE/INSER= T > trigers to check the existence of the Temp table and to force filter fiel= d > 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 t= he > temp table. But if I want to see the contents of a view in table view (Vi= ew > 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.