Re: BUG #13583: Documentation "5.8.2. The Public Schema" misleading

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com>, mina(at)naguib(dot)ca, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13583: Documentation "5.8.2. The Public Schema" misleading
Date: 2015-08-20 21:44:06
Message-ID: 7681.1440107046@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> So basically the key phrase in that paragraph is "by default". The reader
> is intended to take that to mean "with only the schemas created by initdb".

There are actually three assumptions underlying "by default":
1. You haven't changed the default search_path setting.
2. You haven't created a schema matching your own username.
3. You haven't removed the public schema.

The section after this one goes into these details. I don't think that
explaining them all right here would be an improvement in readability.
You have to start somewhere ...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-08-21 16:28:33 Re: BUG #13579: Server crashes after executing plpythonu function
Previous Message David G. Johnston 2015-08-20 19:03:07 Re: BUG #13583: Documentation "5.8.2. The Public Schema" misleading