Re: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database

On Wed, Mar 25, 2020 at 8:05 PM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 16318
> Logged by: Jackey
> Email address: jackeylhm(at)gmail(dot)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.

Per the documentation [1], if you actually specified a non-empty value for
default_tablespace its not a bug, if the default_tablespace is undefined
then the tablespace of the database, which defaults to the default
tablespace anway, should have been used.

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.
>

A basic self-contained example would allow for a conclusive answer as
specific values or various settings and objects are important here.

David J.
1. https://www.postgresql.org/docs/12/manage-ag-tablespaces.html