| -- start_matchsubs |
| -- m/NOTICE: One or more columns in the following table\(s\) do not have statistics: / |
| -- s/.//gs |
| -- m/HINT: For non-partitioned tables, run analyze .+\. For partitioned tables, run analyze rootpartition .+\. See log for columns missing statistics\./ |
| -- s/.//gs |
| -- end_matchsubs |
| -- partition_list_index.sql |
| -- Test partition with CREATE INDEX |
| DROP TABLE if exists mpp3033a; |
| DROP TABLE if exists mpp3033b; |
| CREATE TABLE mpp3033a ( |
| unique1 int4, |
| unique2 int4, |
| two int4, |
| four int4, |
| ten int4, |
| twenty int4, |
| hundred int4, |
| thousand int4, |
| twothousand int4, |
| fivethous int4, |
| tenthous int4, |
| odd int4, |
| even int4, |
| stringu1 name, |
| stringu2 name, |
| string4 name |
| ) distributed by (unique1) partition by list (unique1) ( |
| partition aa values (1,2,3,4,5,6,7,8,9,10), |
| partition bb values (11,12,13,14,15,16,17,18,19,20), |
| default partition default_part |
| ); |
| CREATE TABLE mpp3033b ( |
| unique1 int4, |
| unique2 int4, |
| two int4, |
| four int4, |
| ten int4, |
| twenty int4, |
| hundred int4, |
| thousand int4, |
| twothousand int4, |
| fivethous int4, |
| tenthous int4, |
| odd int4, |
| even int4, |
| stringu1 name, |
| stringu2 name, |
| string4 name |
| ) distributed by (unique1) partition by list (unique1) |
| subpartition by list (unique2) |
| ( |
| partition aa values (1,2,3,4,5,6,7,8,9,10) (subpartition cc values (1,2,3), subpartition dd values (4,5,6) ), |
| partition bb values (11,12,13,14,15,16,17,18,19,20) (subpartition cc values (1,2,3), subpartition dd values (4,5,6) ) |
| ); |
| alter table mpp3033b add default partition default_part; |
| ERROR: no partitions specified at depth 2 |
| \copy mpp3033a from 'data/onek.data'; |
| \copy mpp3033b from 'data/onek.data'; |
| ERROR: no partition of relation "mpp3033b" found for row |
| DETAIL: Partition key of the failing row contains (unique1) = (147). |
| CONTEXT: COPY mpp3033b, line 1: "147 0 1 3 7 7 7 47 147 147 147 14 15 RFAAAA AAAAAA AAAAxx" |
| CREATE INDEX mpp3033a_unique1 ON mpp3033a USING btree(unique1 int4_ops); |
| CREATE INDEX mpp3033a_unique2 ON mpp3033a USING btree(unique2 int4_ops); |
| CREATE INDEX mpp3033a_hundred ON mpp3033a USING btree(hundred int4_ops); |
| CREATE INDEX mpp3033a_stringu1 ON mpp3033a USING btree(stringu1 name_ops); |
| CREATE INDEX mpp3033b_unique1 ON mpp3033b USING btree(unique1 int4_ops); |
| CREATE INDEX mpp3033b_unique2 ON mpp3033b USING btree(unique2 int4_ops); |
| CREATE INDEX mpp3033b_hundred ON mpp3033b USING btree(hundred int4_ops); |
| CREATE INDEX mpp3033b_stringu1 ON mpp3033b USING btree(stringu1 name_ops); |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 0 |
| (1 row) |
| |
| reindex index mpp3033a_unique1; |
| reindex index mpp3033a_unique2; |
| reindex index mpp3033a_hundred; |
| reindex index mpp3033a_stringu1; |
| reindex index mpp3033b_unique1; |
| reindex index mpp3033b_unique2; |
| reindex index mpp3033b_hundred; |
| reindex index mpp3033b_stringu1; |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 0 |
| (1 row) |
| |
| drop index mpp3033a_unique1; |
| drop index mpp3033a_unique2; |
| drop index mpp3033a_hundred; |
| drop index mpp3033a_stringu1; |
| drop index mpp3033b_unique1; |
| drop index mpp3033b_unique2; |
| drop index mpp3033b_hundred; |
| drop index mpp3033b_stringu1; |
| CREATE INDEX mpp3033a_unique1 ON mpp3033a (unique1); |
| CREATE INDEX mpp3033a_unique2 ON mpp3033a (unique2); |
| CREATE INDEX mpp3033a_hundred ON mpp3033a (hundred); |
| CREATE INDEX mpp3033a_stringu1 ON mpp3033a (stringu1); |
| CREATE INDEX mpp3033b_unique1 ON mpp3033b (unique1); |
| CREATE INDEX mpp3033b_unique2 ON mpp3033b (unique2); |
| CREATE INDEX mpp3033b_hundred ON mpp3033b (hundred); |
| CREATE INDEX mpp3033b_stringu1 ON mpp3033b (stringu1); |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 0 |
| (1 row) |
| |
| reindex index mpp3033a_unique1; |
| reindex index mpp3033a_unique2; |
| reindex index mpp3033a_hundred; |
| reindex index mpp3033a_stringu1; |
| reindex index mpp3033b_unique1; |
| reindex index mpp3033b_unique2; |
| reindex index mpp3033b_hundred; |
| reindex index mpp3033b_stringu1; |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 0 |
| (1 row) |
| |
| drop index mpp3033a_unique1; |
| drop index mpp3033a_unique2; |
| drop index mpp3033a_hundred; |
| drop index mpp3033a_stringu1; |
| drop index mpp3033b_unique1; |
| drop index mpp3033b_unique2; |
| drop index mpp3033b_hundred; |
| drop index mpp3033b_stringu1; |
| CREATE UNIQUE INDEX mpp3033a_unique1 ON mpp3033a (unique1); |
| CREATE UNIQUE INDEX mpp3033a_unique2 ON mpp3033a (unique2); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033a_hundred ON mpp3033a (hundred); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033a_stringu1 ON mpp3033a (stringu1); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033b_unique1 ON mpp3033b (unique1); |
| ERROR: unique constraint on partitioned table must include all partitioning columns |
| DETAIL: UNIQUE constraint on table "mpp3033b_1_prt_aa" lacks column "unique2" which is part of the partition key. |
| CREATE UNIQUE INDEX mpp3033b_unique2 ON mpp3033b (unique2); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033b_hundred ON mpp3033b (hundred); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033b_stringu1 ON mpp3033b (stringu1); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 0 |
| (1 row) |
| |
| reindex index mpp3033a_unique1; |
| reindex index mpp3033a_unique2; |
| ERROR: relation "mpp3033a_unique2" does not exist |
| reindex index mpp3033a_hundred; |
| ERROR: relation "mpp3033a_hundred" does not exist |
| reindex index mpp3033a_stringu1; |
| ERROR: relation "mpp3033a_stringu1" does not exist |
| reindex index mpp3033b_unique1; |
| ERROR: relation "mpp3033b_unique1" does not exist |
| reindex index mpp3033b_unique2; |
| ERROR: relation "mpp3033b_unique2" does not exist |
| reindex index mpp3033b_hundred; |
| ERROR: relation "mpp3033b_hundred" does not exist |
| reindex index mpp3033b_stringu1; |
| ERROR: relation "mpp3033b_stringu1" does not exist |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 0 |
| (1 row) |
| |
| drop index mpp3033a_unique1; |
| drop index mpp3033a_unique2; |
| ERROR: index "mpp3033a_unique2" does not exist |
| drop index mpp3033a_hundred; |
| ERROR: index "mpp3033a_hundred" does not exist |
| drop index mpp3033a_stringu1; |
| ERROR: index "mpp3033a_stringu1" does not exist |
| drop index mpp3033b_unique1; |
| ERROR: index "mpp3033b_unique1" does not exist |
| drop index mpp3033b_unique2; |
| ERROR: index "mpp3033b_unique2" does not exist |
| drop index mpp3033b_hundred; |
| ERROR: index "mpp3033b_hundred" does not exist |
| drop index mpp3033b_stringu1; |
| ERROR: index "mpp3033b_stringu1" does not exist |
| CREATE INDEX mpp3033a_unique1 ON mpp3033a USING bitmap (unique1); |
| CREATE INDEX mpp3033a_unique2 ON mpp3033a USING bitmap (unique2); |
| CREATE INDEX mpp3033a_hundred ON mpp3033a USING bitmap (hundred); |
| CREATE INDEX mpp3033a_stringu1 ON mpp3033a USING bitmap (stringu1); |
| CREATE INDEX mpp3033b_unique1 ON mpp3033b USING bitmap (unique1); |
| CREATE INDEX mpp3033b_unique2 ON mpp3033b USING bitmap (unique2); |
| CREATE INDEX mpp3033b_hundred ON mpp3033b USING bitmap (hundred); |
| CREATE INDEX mpp3033b_stringu1 ON mpp3033b USING bitmap (stringu1); |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 0 |
| (1 row) |
| |
| reindex index mpp3033a_unique1; |
| reindex index mpp3033a_unique2; |
| reindex index mpp3033a_hundred; |
| reindex index mpp3033a_stringu1; |
| reindex index mpp3033b_unique1; |
| reindex index mpp3033b_unique2; |
| reindex index mpp3033b_hundred; |
| reindex index mpp3033b_stringu1; |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 0 |
| (1 row) |
| |
| -- partition_range_index.sql |
| -- Test partition with CREATE INDEX |
| DROP TABLE if exists mpp3033a; |
| DROP TABLE if exists mpp3033b; |
| CREATE TABLE mpp3033a ( |
| unique1 int4, |
| unique2 int4, |
| two int4, |
| four int4, |
| ten int4, |
| twenty int4, |
| hundred int4, |
| thousand int4, |
| twothousand int4, |
| fivethous int4, |
| tenthous int4, |
| odd int4, |
| even int4, |
| stringu1 name, |
| stringu2 name, |
| string4 name |
| ) distributed by (unique1) partition by range (unique1) |
| ( partition aa start (0) end (1000) every (100), default partition default_part ); |
| CREATE TABLE mpp3033b ( |
| unique1 int4, |
| unique2 int4, |
| two int4, |
| four int4, |
| ten int4, |
| twenty int4, |
| hundred int4, |
| thousand int4, |
| twothousand int4, |
| fivethous int4, |
| tenthous int4, |
| odd int4, |
| even int4, |
| stringu1 name, |
| stringu2 name, |
| string4 name |
| ) distributed by (unique1) partition by range (unique1) |
| subpartition by range (unique2) subpartition template ( start (0) end (1000) every (500) ) |
| ( start (0) end (1000) every (200)); |
| alter table mpp3033b add default partition default_part; |
| \copy mpp3033a from 'data/onek.data'; |
| \copy mpp3033b from 'data/onek.data'; |
| drop index if exists mpp3033a_unique1; |
| NOTICE: index "mpp3033a_unique1" does not exist, skipping |
| drop index if exists mpp3033a_unique2; |
| NOTICE: index "mpp3033a_unique2" does not exist, skipping |
| drop index if exists mpp3033a_hundred; |
| NOTICE: index "mpp3033a_hundred" does not exist, skipping |
| drop index if exists mpp3033a_stringu1; |
| NOTICE: index "mpp3033a_stringu1" does not exist, skipping |
| drop index if exists mpp3033b_unique1; |
| NOTICE: index "mpp3033b_unique1" does not exist, skipping |
| drop index if exists mpp3033b_unique2; |
| NOTICE: index "mpp3033b_unique2" does not exist, skipping |
| drop index if exists mpp3033b_hundred; |
| NOTICE: index "mpp3033b_hundred" does not exist, skipping |
| drop index if exists mpp3033b_stringu1; |
| NOTICE: index "mpp3033b_stringu1" does not exist, skipping |
| CREATE INDEX mpp3033a_unique1 ON mpp3033a USING btree(unique1 int4_ops); |
| CREATE INDEX mpp3033a_unique2 ON mpp3033a USING btree(unique2 int4_ops); |
| CREATE INDEX mpp3033a_hundred ON mpp3033a USING btree(hundred int4_ops); |
| CREATE INDEX mpp3033a_stringu1 ON mpp3033a USING btree(stringu1 name_ops); |
| CREATE INDEX mpp3033b_unique1 ON mpp3033b USING btree(unique1 int4_ops); |
| CREATE INDEX mpp3033b_unique2 ON mpp3033b USING btree(unique2 int4_ops); |
| CREATE INDEX mpp3033b_hundred ON mpp3033b USING btree(hundred int4_ops); |
| CREATE INDEX mpp3033b_stringu1 ON mpp3033b USING btree(stringu1 name_ops); |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| reindex index mpp3033a_unique1; |
| reindex index mpp3033a_unique2; |
| reindex index mpp3033a_hundred; |
| reindex index mpp3033a_stringu1; |
| reindex index mpp3033b_unique1; |
| reindex index mpp3033b_unique2; |
| reindex index mpp3033b_hundred; |
| reindex index mpp3033b_stringu1; |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| drop index mpp3033a_unique1; |
| drop index mpp3033a_unique2; |
| drop index mpp3033a_hundred; |
| drop index mpp3033a_stringu1; |
| drop index mpp3033b_unique1; |
| drop index mpp3033b_unique2; |
| drop index mpp3033b_hundred; |
| drop index mpp3033b_stringu1; |
| CREATE INDEX mpp3033a_unique1 ON mpp3033a (unique1); |
| CREATE INDEX mpp3033a_unique2 ON mpp3033a (unique2); |
| CREATE INDEX mpp3033a_hundred ON mpp3033a (hundred); |
| CREATE INDEX mpp3033a_stringu1 ON mpp3033a (stringu1); |
| CREATE INDEX mpp3033b_unique1 ON mpp3033b (unique1); |
| CREATE INDEX mpp3033b_unique2 ON mpp3033b (unique2); |
| CREATE INDEX mpp3033b_hundred ON mpp3033b (hundred); |
| CREATE INDEX mpp3033b_stringu1 ON mpp3033b (stringu1); |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| reindex index mpp3033a_unique1; |
| reindex index mpp3033a_unique2; |
| reindex index mpp3033a_hundred; |
| reindex index mpp3033a_stringu1; |
| reindex index mpp3033b_unique1; |
| reindex index mpp3033b_unique2; |
| reindex index mpp3033b_hundred; |
| reindex index mpp3033b_stringu1; |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| drop index mpp3033a_unique1; |
| drop index mpp3033a_unique2; |
| drop index mpp3033a_hundred; |
| drop index mpp3033a_stringu1; |
| drop index mpp3033b_unique1; |
| drop index mpp3033b_unique2; |
| drop index mpp3033b_hundred; |
| drop index mpp3033b_stringu1; |
| CREATE UNIQUE INDEX mpp3033a_unique1 ON mpp3033a (unique1); |
| CREATE UNIQUE INDEX mpp3033a_unique2 ON mpp3033a (unique2); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033a_hundred ON mpp3033a (hundred); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033a_stringu1 ON mpp3033a (stringu1); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033b_unique1 ON mpp3033b (unique1); |
| ERROR: unique constraint on partitioned table must include all partitioning columns |
| DETAIL: UNIQUE constraint on table "mpp3033b_1_prt_1" lacks column "unique2" which is part of the partition key. |
| CREATE UNIQUE INDEX mpp3033b_unique2 ON mpp3033b (unique2); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033b_hundred ON mpp3033b (hundred); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| CREATE UNIQUE INDEX mpp3033b_stringu1 ON mpp3033b (stringu1); |
| ERROR: UNIQUE index must contain all columns in the table's distribution key |
| DETAIL: Distribution key column "unique1" is not included in the constraint. |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| reindex index mpp3033a_unique1; |
| reindex index mpp3033a_unique2; |
| ERROR: relation "mpp3033a_unique2" does not exist |
| reindex index mpp3033a_hundred; |
| ERROR: relation "mpp3033a_hundred" does not exist |
| reindex index mpp3033a_stringu1; |
| ERROR: relation "mpp3033a_stringu1" does not exist |
| reindex index mpp3033b_unique1; |
| ERROR: relation "mpp3033b_unique1" does not exist |
| reindex index mpp3033b_unique2; |
| ERROR: relation "mpp3033b_unique2" does not exist |
| reindex index mpp3033b_hundred; |
| ERROR: relation "mpp3033b_hundred" does not exist |
| reindex index mpp3033b_stringu1; |
| ERROR: relation "mpp3033b_stringu1" does not exist |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| drop index mpp3033a_unique1; |
| drop index mpp3033a_unique2; |
| ERROR: index "mpp3033a_unique2" does not exist |
| drop index mpp3033a_hundred; |
| ERROR: index "mpp3033a_hundred" does not exist |
| drop index mpp3033a_stringu1; |
| ERROR: index "mpp3033a_stringu1" does not exist |
| drop index mpp3033b_unique1; |
| ERROR: index "mpp3033b_unique1" does not exist |
| drop index mpp3033b_unique2; |
| ERROR: index "mpp3033b_unique2" does not exist |
| drop index mpp3033b_hundred; |
| ERROR: index "mpp3033b_hundred" does not exist |
| drop index mpp3033b_stringu1; |
| ERROR: index "mpp3033b_stringu1" does not exist |
| CREATE INDEX mpp3033a_unique1 ON mpp3033a USING bitmap (unique1); |
| CREATE INDEX mpp3033a_unique2 ON mpp3033a USING bitmap (unique2); |
| CREATE INDEX mpp3033a_hundred ON mpp3033a USING bitmap (hundred); |
| CREATE INDEX mpp3033a_stringu1 ON mpp3033a USING bitmap (stringu1); |
| CREATE INDEX mpp3033b_unique1 ON mpp3033b USING bitmap (unique1); |
| CREATE INDEX mpp3033b_unique2 ON mpp3033b USING bitmap (unique2); |
| CREATE INDEX mpp3033b_hundred ON mpp3033b USING bitmap (hundred); |
| CREATE INDEX mpp3033b_stringu1 ON mpp3033b USING bitmap (stringu1); |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| reindex index mpp3033a_unique1; |
| reindex index mpp3033a_unique2; |
| reindex index mpp3033a_hundred; |
| reindex index mpp3033a_stringu1; |
| reindex index mpp3033b_unique1; |
| reindex index mpp3033b_unique2; |
| reindex index mpp3033b_hundred; |
| reindex index mpp3033b_stringu1; |
| select count(*) from mpp3033a; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| select count(*) from mpp3033b; |
| count |
| ------- |
| 1000 |
| (1 row) |
| |
| create table mpp6379(a int, b date, primary key (a,b)) distributed by (a) partition by range (b) (partition p1 end ('2009-01-02'::date)); |
| insert into mpp6379( a, b ) values( 1, '20090101' ); |
| insert into mpp6379( a, b ) values( 1, '20090101' ); |
| ERROR: duplicate key value violates unique constraint "mpp6379_1_prt_p1_pkey" |
| DETAIL: Key (a, b)=(1, 01-01-2009) already exists. |
| alter table mpp6379 add partition p2 end(date '2009-01-03'); |
| insert into mpp6379( a, b ) values( 2, '20090102' ); |
| insert into mpp6379( a, b ) values( 2, '20090102' ); |
| ERROR: duplicate key value violates unique constraint "mpp6379_1_prt_p2_pkey" |
| DETAIL: Key (a, b)=(2, 01-02-2009) already exists. |
| drop table mpp6379; |
| -- Creating an index on a partitioned table makes the partitions |
| -- automatically get the index |
| create table gpidxpart (a int, b int, c text) |
| partition by range (a) |
| subpartition by range(b) |
| subpartition template |
| (start(1) end (3)) |
| (start (1) end (3)); |
| NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Apache Cloudberry data distribution key for this table. |
| HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. |
| -- relhassubclass of a partitioned index is false before creating any partition. |
| -- It will be set after the first partition is created. |
| create index gpidxpart_idx on gpidxpart (a); |
| select relhassubclass from pg_class where relname = 'gpidxpart_idx'; |
| relhassubclass |
| ---------------- |
| t |
| (1 row) |
| |
| drop index gpidxpart_idx; |
| -- Even with partitions, relhassubclass should not be set if a partitioned |
| -- index is created only on the parent. |
| create index gpidxpart_idx on only gpidxpart(a); |
| select relhassubclass from pg_class where relname = 'gpidxpart_idx'; |
| relhassubclass |
| ---------------- |
| f |
| (1 row) |
| |
| drop index gpidxpart_idx; |
