X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7A1A1D9D64 for ; Wed, 16 Nov 2005 20:50:39 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80023-04 for ; Thu, 17 Nov 2005 00:50:41 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id 69CA9D8417 for ; Wed, 16 Nov 2005 20:50:34 -0400 (AST) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 16 Nov 2005 21:52:52 -0300 X-IronPort-AV: i="3.97,339,1125892800"; d="scan'208"; a="27754995:sNHT194237090" Received: from alvh.no-ip.org (216.155.78.23) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 43501597004335AC; Wed, 16 Nov 2005 21:50:34 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 3786EC2DC19; Wed, 16 Nov 2005 21:50:43 -0300 (CLST) Date: Wed, 16 Nov 2005 21:50:43 -0300 From: Alvaro Herrera To: Bruce Momjian Cc: "Goulet, Dick" , Tom Lane , Peter Eisentraut , pgsql-interfaces@postgresql.org, Scott Lamb Subject: Re: Incremental results from libpq Message-ID: <20051117005043.GD24640@surnet.cl> Mail-Followup-To: Bruce Momjian , "Goulet, Dick" , Tom Lane , Peter Eisentraut , pgsql-interfaces@postgresql.org, Scott Lamb References: <4001DEAF7DF9BD498B58B45051FBEA6502EF55DA@25exch1.vicorpower.vicr.com> <200511162013.jAGKDHY22079@candle.pha.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200511162013.jAGKDHY22079@candle.pha.pa.us> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.766 required=5 tests=[AWL=-0.480, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, RCVD_IN_NJABL_PROXY=0.327] X-Spam-Score: 1.766 X-Spam-Level: * X-Archive-Number: 200511/35 X-Sequence-Number: 5831 Bruce Momjian wrote: > Goulet, Dick wrote: > > > If I may, one item that would be of extreme use to our location > > would be global temporary tables. These have existed since Oracle 9.0. > > They are defined once and then used by clients as needed. Each session > > is ignorant of the data of any other session and once you disconnect the > > data from the session disappears. Truly a real temporary table. > > How is it better than what we have now? Global temporary tables are defined only once (not once per session), and the schema (definition) is known to all sessions. Only the content is private to each session. At least that's what I remember since the last time I read the spec on it ... -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support