Re: BUG #13583: Documentation "5.8.2. The Public Schema" misleading - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #13583: Documentation "5.8.2. The Public Schema" misleading
Date
Msg-id CAMkU=1xMdZeAm6GncVbEYs+=gicSLd+BYdZ7-U25KQ6p5q96dA@mail.gmail.com
Whole thread Raw
In response to BUG #13583: Documentation "5.8.2. The Public Schema" misleading  (mina@naguib.ca)
List pgsql-bugs
On Thu, Aug 20, 2015 at 10:51 AM, <mina@naguib.ca> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13583
> Logged by:          Mina Naguib
> Email address:      mina@naguib.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

pgsql-bugs by date:

Previous
From: mina@naguib.ca
Date:
Subject: BUG #13583: Documentation "5.8.2. The Public Schema" misleading
Next
From: John McKown
Date:
Subject: Re: BUG #13583: Documentation "5.8.2. The Public Schema" misleading