From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: jackeylhm@gmail.com
Subject: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
Date: Thu, 26 Mar 2020 03:04:38 +0000
Message-ID: <16318-69465df45ec3b430@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16318
Logged by: Jackey
Email address: jackeylhm@gmail.com
PostgreSQL version: 11.6
Operating system: Ubuntu
Description:
I created a table and an index without specifying a tablespace name, and
expect the table and index will use the database's tablespace. But I found
the table and index is using the server's setting default_tablespace,
instead of the database's tablespace. Is this a bug? or this is the expected
behavior? I come from an Oracle DBA 's background, expecting all objects
created in a database will inherit the tablespace's setting of the database.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, jackeylhm@gmail.com
Subject: Re: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
In-Reply-To: <16318-69465df45ec3b430@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox