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 2FBD352F0E for ; Fri, 12 Aug 2005 07:02:24 -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 18332-01 for ; Fri, 12 Aug 2005 10:02:19 +0000 (GMT) Received: from mail3.cc.huji.ac.il (real-outmail.cc.huji.ac.il [132.64.1.21]) by svr1.postgresql.org (Postfix) with ESMTP id 8628152ED3 for ; Fri, 12 Aug 2005 07:02:18 -0300 (ADT) Received: from mail3.cc.huji.ac.il (localhost [127.0.0.1]) by mail3.cc.huji.ac.il (Postfix) with SMTP id A8BDF8E690; Fri, 12 Aug 2005 13:02:16 +0300 (IDT) Received: by mail3.cc.huji.ac.il (Postfix, from userid 31998) id 9D2F78E695; Fri, 12 Aug 2005 13:02:16 +0300 (IDT) Received: from [132.64.36.241] (di8-36241.dialin.huji.ac.il [132.64.36.241]) by mail3.cc.huji.ac.il (Postfix) with ESMTP id 0757B8E690; Fri, 12 Aug 2005 13:02:15 +0300 (IDT) Message-ID: <411B4EDA.1080308@mail.jct.ac.il> Date: Thu, 12 Aug 2004 13:04:58 +0200 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Ian FREISLICH , pgsql-admin@postgresql.org Subject: Re: Schema authorization after create database. References: <21954.1123769339@sss.pgh.pa.us> In-Reply-To: <21954.1123769339@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.826 from Thu Aug 11 19:33:01 2005 CEST X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.541 tagged_above=0 required=5 tests=[AWL=-0.541, DATE_IN_PAST_96_XX=1.082] X-Spam-Level: X-Archive-Number: 200508/152 X-Sequence-Number: 18471 Yep.But this is a little strange ,maybe we should ask to change it? Evgeny. Tom Lane wrote: > Ian FREISLICH writes: > >>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? > > > That's the way it's supposed to work. CREATE DATABASE does not change > anything inside the copied database. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster