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

On Thu, Aug 20, 2015 at 10:51 AM, <mina(at)naguib(dot)ca> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 13583
> Logged by: Mina Naguib
> Email address: mina(at)naguib(dot)ca
> PostgreSQL version: 9.5alpha2
> Operating system: N/A
> Description:
>
> This section of the documentation states:
>
> "... we created tables without specifying any schema ... are automatically
> put into a schema named "public" ..."
>
> This is not true. At least from my tests, the search_path is taken into
> account.
>
> My search_path is set to "$user",public, and therefore a barebones "create
> table foo();" creates the table foo in the "mina" schema, not the "public"
> schema.
>

By default, there is no schema named "mina". That part of the
documentation is describing the behavior under this default condition. The
next section goes on to explain what happens when you have created a schema
that matches your user name.

Cheers,

Jeff