From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: onavratil@monetplus.cz
Subject: BUG #18709: Explicit tablespace pg_default not working when creating of indices in partitioned tables
Date: Thu, 14 Nov 2024 15:23:41 +0000
Message-ID: <18709-cd75136db7addf69@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18709
Logged by: Ondřej Navrátil
Email address: onavratil@monetplus.cz
PostgreSQL version: 14.13
Operating system: Linux
Description:
Long story short, lets have a partitioned table:
```
create table test_table (
id integer,
description text
) partition BY range(id);
```
...and create some tablespace. Now this works nicely:
```
create index descri_index on test_table (description) tablespace
my_custom_tablespace;
```
..but for some reason, the same returns an error when pg_default is
explicitly requested as a tablespace
```
create index descri_index2 on test_table (description) tablespace
pg_default;
```
psql:commands.sql:9: ERROR: cannot specify default tablespace for
partitioned relations
In some versions, same applies to `create table ... partitioned by` - using
a custom tablespace works, but explicitly denoting pg_default as the target
yields an error.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, onavratil@monetplus.cz
Subject: Re: BUG #18709: Explicit tablespace pg_default not working when creating of indices in partitioned tables
In-Reply-To: <18709-cd75136db7addf69@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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