Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8C8A4B5DBC1 for ; Sat, 13 Aug 2011 13:13:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 79017-07 for ; Sat, 13 Aug 2011 16:13:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-2.01.com (smtp-2.01.com [38.102.63.181]) by mail.postgresql.org (Postfix) with ESMTP id 93A10B5DBD0 for ; Sat, 13 Aug 2011 13:13:35 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-2.01.com (Postfix) with ESMTP id 52D0C1ADD2F for ; Sat, 13 Aug 2011 11:13:34 -0500 (CDT) Received: from smtp-2.01.com ([127.0.0.1]) by localhost (smtp-2.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PZcNM2hAEt+I for ; Sat, 13 Aug 2011 11:13:34 -0500 (CDT) Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by smtp-2.01.com (Postfix) with ESMTP id 247861ADD2A for ; Sat, 13 Aug 2011 11:13:34 -0500 (CDT) Received: from mail-1.01.com (mail-1.01.com [38.102.63.171]) by smtp-2.01.com (Postfix) with ESMTP id 051181ADBEB; Sat, 13 Aug 2011 11:13:34 -0500 (CDT) Date: Sat, 13 Aug 2011 11:13:33 -0500 (CDT) From: Joshua Berkus To: Alexander Perepelica , Robert Haas Cc: pgsql-testers@postgresql.org Message-ID: <1203418743.109759.1313252013903.JavaMail.root@mail-1.01.com> In-Reply-To: Subject: Re: Can't create unlogged table MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [208.54.39.136] X-Mailer: Zimbra 7.1.1_GA_3223 (ZimbraWebClient - SAF3 (Linux)/7.1.1_GA_3221) 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/5 X-Sequence-Number: 257 Alexander, I don't know, that looks like a bug. Robert? --Josh ----- Original Message ----- > > Hi! > I try create unlogged table in 9.1beta3 (linux x86_64) execute such > code: > > create unlogged table public .test ( > id serial primary key , > some_text text ); > and what I see is: > > ERROR: only temporary relations may be created in temporary schemas > What I do wrong? > > Thank you, > Alexander >