Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 375A7632D50 for ; Sat, 24 Apr 2010 19:29:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06841-09 for ; Sat, 24 Apr 2010 22:29:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148111.authsmtp.net (outmail148111.authsmtp.net [62.13.148.111]) by mail.postgresql.org (Postfix) with ESMTP id 5CA22632646 for ; Sat, 24 Apr 2010 19:29:08 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o3OMT5UX099286; Sat, 24 Apr 2010 23:29:05 +0100 (BST) Received: from [192.168.0.2] (88-110-156-192.dynamic.dsl.as9105.com [88.110.156.192]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id o3OMT3oo042581; Sat, 24 Apr 2010 23:29:03 +0100 (BST) Subject: Re: global temporary tables From: Simon Riggs To: Robert Haas Cc: pgsql-hackers@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Sat, 24 Apr 2010 23:29:02 +0100 Message-Id: <1272148142.4161.1598.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: c9968ffb-4ff0-11df-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagFbbElD HGQLWlREUl57W2p/ awkfZQ1DY0tOQQRv VlZIS1BNEQ1vHhxP WR1hL31xKFpGfHx1 bUcsX3VaWAopfE97 ShgCR3ACMzFgdWEe BBZFfgQGIh5Kfh1H bFR2U3sIYG1JBC9q VzwTFhsSEA9kHWxa RgYHJFZaXUsOBjkm TgoTVSkmF0kIXE0A X-Authentic-SMTP: 61633235383639.1014:706/Kp X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/1126 X-Sequence-Number: 161238 On Fri, 2010-04-23 at 22:52 -0400, Robert Haas wrote: > Thoughts? Only a requirement: that we design this in a way that will allow temp tables to be used during Hot Standby. I make not other comment. -- Simon Riggs www.2ndQuadrant.com