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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #16318: The default tablespace of a table and index is notinheriting the tablespace of database
Дата
Msg-id CAKFQuwa2DTZHQh+SG2MzSHvNm2Fpc8FPTJv=0Uvjpabenp+Qtg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16318: The default tablespace of a table and index is notinheriting the tablespace of database  (Jackey Lin <jackeylhm@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Wed, Mar 25, 2020 at 8:05 PM PG Bug reporting form <noreply@postgresql.org> wrote:
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.

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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
Следующее
От: Fahar Abbas
Дата:
Сообщение: Re: BUG #16315: Installing as SYSTEM generates error when icaclscommand runs