Postgres Pro
Downloads
Home   >   mailing lists

Re: public schema owner for newly created database - Mailing list pgsql-general

From Alberto Cabello Sánchez
Subject Re: public schema owner for newly created database
Date
Msg-id 20140408130511.4a411118200e460ec50cd524@unex.es
Whole thread Raw
In response to public schema owner for newly created database  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: public schema owner for newly created database  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view 
On Tue, 08 Apr 2014 12:45:29 +0200
Thomas Kellerer <spam_eater@gmx.net> wrote:
>
> But I would have expected the owner of the database to be the owner of any
> "object" that is created during database initialization.
>
> Do I have a wrong assumption here?

It seems you do. See:

Why Postgresql Public Schema Is Not Owned By The DB Owner By Default?

http://www.postgresql.org/message-id/4527.1225340193@sss.pgh.pa.us


--
Alberto Cabello Sánchez
<alberto@unex.es>

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: public schema owner for newly created database
Next
From: Raymond O'Donnell
Date:
Subject: Re: import .sql file into PostgreSQL database