pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
3+ messages / 3 participants
[nested] [flat]

* BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
@ 2020-03-26 03:04 PG Bug reporting form <noreply@postgresql.org>
  2020-03-26 03:40 ` Re: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: PG Bug reporting form @ 2020-03-26 03:04 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: jackeylhm@gmail.com

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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
  2020-03-26 03:04 BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database PG Bug reporting form <noreply@postgresql.org>
@ 2020-03-26 03:40 ` David G. Johnston <david.g.johnston@gmail.com>
  2020-03-26 06:51   ` Re: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database Jackey Lin <jackeylhm@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: David G. Johnston @ 2020-03-26 03:40 UTC (permalink / raw)
  To: jackeylhm@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database
  2020-03-26 03:04 BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database PG Bug reporting form <noreply@postgresql.org>
  2020-03-26 03:40 ` Re: BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database David G. Johnston <david.g.johnston@gmail.com>
@ 2020-03-26 06:51   ` Jackey Lin <jackeylhm@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jackey Lin @ 2020-03-26 06:51 UTC (permalink / raw)
  To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Thanks a lot, David

For your clarification and help.

Regards
Jackey

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

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2020-03-26 06:51 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-03-26 03:04 BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database PG Bug reporting form <noreply@postgresql.org>
2020-03-26 03:40 ` David G. Johnston <david.g.johnston@gmail.com>
2020-03-26 06:51   ` Jackey Lin <jackeylhm@gmail.com>

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