| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> | 
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org | 
| Cc: | onavratil(at)monetplus(dot)cz | 
| Subject: | BUG #18709: Explicit tablespace pg_default not working when creating of indices in partitioned tables | 
| Date: | 2024-11-14 15:23:41 | 
| Message-ID: | 18709-cd75136db7addf69@postgresql.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
The following bug has been logged on the website:
Bug reference:      18709
Logged by:          Ondřej Navrátil
Email address:      onavratil(at)monetplus(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2024-11-14 15:25:48 | Re: BUG #18708: regex problem: (?:[^\d\D]){0} asserts with "lp->nouts == 0 && rp->nins == 0" | 
| Previous Message | Greg Sabino Mullane | 2024-11-14 15:11:25 | Re: Export PostgreSQL database into mysql database |