X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F1FEE52CA6 for ; Thu, 11 Aug 2005 07:52:34 -0300 (ADT) 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 30681-07 for ; Thu, 11 Aug 2005 10:52:32 +0000 (GMT) Received: from mail3.cc.huji.ac.il (mail3.cc.huji.ac.il [132.64.1.21]) by svr1.postgresql.org (Postfix) with ESMTP id 7B37452C83 for ; Thu, 11 Aug 2005 07:52:29 -0300 (ADT) Received: from mail3.cc.huji.ac.il (localhost [127.0.0.1]) by mail3.cc.huji.ac.il (Postfix) with SMTP id 3E11F8DE39; Thu, 11 Aug 2005 13:52:29 +0300 (IDT) Received: by mail3.cc.huji.ac.il (Postfix, from userid 31998) id 2F4AD8DE44; Thu, 11 Aug 2005 13:52:29 +0300 (IDT) Received: from [132.64.52.127] (evegeni.mm.huji.ac.il [132.64.52.127]) by mail3.cc.huji.ac.il (Postfix) with ESMTP id E0A3C8DE39; Thu, 11 Aug 2005 13:52:28 +0300 (IDT) Message-ID: <42FB2F03.9040209@mail.jct.ac.il> Date: Thu, 11 Aug 2005 13:57:07 +0300 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ian FREISLICH Cc: pgsql-admin@postgresql.org Subject: Re: Schema authorization after create database. References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.825 from Wed Aug 10 19:29:41 2005 CEST X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200508/141 X-Sequence-Number: 18460 We have simular behavor: createdb -U user1 mydb pg_restore -U user1 -d mydb filename And the pg_restore complains about the wrong user .I have alwais wolk around this as supreuser. Evgeny Ian FREISLICH wrote: >Hi > >I ran into this little astonishment yesterday on 7.4.8. When I >create a database connected as the super user using: > >CREATE DATABASE foo OWNER = foo; > >The database is indeed owned by user foo, but the automatically >created public schema is is owned by the database super user. Should >this schema not be created as owned by the database owner specified >in the CREATE DATABASE command? > >Our work around is to drop the public schema and recreate it after >reconnecting as the database owner, but that seems like work I >shouldn't have to do. > >Is this a problem or am I expecting something that I shouldn't? > >Ian > >-- >Ian Freislich > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >