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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: eus(at)member(dot)fsf(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why Postgresql Public Schema Is Not Owned By The DB Owner By Default
Date: 2008-10-30 04:16:33
Message-ID: 4527.1225340193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Eus <eus(at)member(dot)fsf(dot)org> writes:
> Why does Postgresql by default assign the ownership of the public schema of a DB to "postgres" instead of the owner of the 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abdul Rahman 2008-10-30 04:42:00 Re: Replication with slony-I
Previous Message Tom Lane 2008-10-30 04:12:18 Re: valid use of wildcard