Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 54690B5DBDB for ; Tue, 9 Aug 2011 14:30:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 66229-05 for ; Tue, 9 Aug 2011 17:30:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail5.sea5.speakeasy.net (mail5.sea5.speakeasy.net [69.17.117.49]) by mail.postgresql.org (Postfix) with ESMTP id EDB08B5DBD6 for ; Tue, 9 Aug 2011 14:30:51 -0300 (ADT) Received: (qmail 6977 invoked from network); 9 Aug 2011 17:30:49 -0000 Received: from 25-76-42-72.skybeam.com (HELO [192.168.2.16]) (sribe@elevated-dev.com@[72.42.76.25]) (envelope-sender ) by mail5.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 9 Aug 2011 17:30:49 -0000 Subject: Re: Read-only postgres instance Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=utf-8 From: Scott Ribe In-Reply-To: Date: Tue, 9 Aug 2011 11:30:48 -0600 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <725251312532201@web67.yandex.ru> To: =?utf-8?Q?pasman_pasma=C5=84ski?= X-Mailer: Apple Mail (2.1084) 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: 201108/64 X-Sequence-Number: 38051 Creating a temp table is not a read-only operation. On Aug 9, 2011, at 11:19 AM, pasman pasma=C5=84ski wrote: > What with queries need temporary tables? --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice