PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16318
PG Version11.6
OSUbuntu
Opened2020-03-26 03:04:38+00
Reported byJackey
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16318
Logged by:          Jackey
Email address:      (redacted)
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.

Messages

DateAuthorSubject
2020-03-26 03:04:38+00PG Bug reporting formBUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
2020-03-26 03:40:24+00"David G(dot) Johnston"Re: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
2020-03-26 06:51:40+00Jackey LinRe: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database