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

Thanks a lot, David

For your clarification and help.

Regards
Jackey

On Thu, Mar 26, 2020 at 11:40 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

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