Postgres Pro
Downloads
Home   >   mailing lists

Re: Why Postgresql Public Schema Is Not Owned By The DB Owner By Default - Mailing list pgsql-general

From Tom Lane
Subject Re: Why Postgresql Public Schema Is Not Owned By The DB Owner By Default
Date
Msg-id 4527.1225340193@sss.pgh.pa.us
Whole thread Raw
In response to Why Postgresql Public Schema Is Not Owned By The DB Owner By Default  (Eus <eus@member.fsf.org>)
Responses Re: Why Postgresql Public Schema Is Not Owned By The DB Owner By Default  (Eus <eus@member.fsf.org>)
List pgsql-general
Tree view 
Eus <eus@member.fsf.org> writes:
> Why does Postgresql by default assign the ownership of the public schema of a DB to "postgres" instead of the owner
ofthe DB itself? 

Because it'd be extremely difficult to do otherwise (given the way that
CREATE DATABASE works) and it's not at all clear that it'd be a good
idea anyway.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: valid use of wildcard
Next
From: Abdul Rahman
Date:
Subject: Re: Replication with slony-I