pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #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