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

From: mina(at)naguib(dot)ca
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13583: Documentation "5.8.2. The Public Schema" misleading
Date: 2015-08-20 17:51:49
Message-ID: 20150820175149.7668.94521@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2015-08-20 18:11:00 Re: BUG #13583: Documentation "5.8.2. The Public Schema" misleading
Previous Message john_zhu 2015-08-20 16:43:57 BUG #13582: ODBC drvier 9.03.0400 report SQL_NULLDATA when timestamp data has microsecond present