This is an automated email from the ASF dual-hosted git repository.
djwang pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/main by this push:
new a042ccce8e9 Add more contrib extensions to ic-contrib-check
a042ccce8e9 is described below
commit a042ccce8e9a76c96f7776f4c903c0bfe46fec17
Author: reshke kirill <[email protected]>
AuthorDate: Sat Dec 27 05:51:37 2025 +0000
Add more contrib extensions to ic-contrib-check
Also fix pgstattuple expected output.
---
.github/workflows/build-cloudberry.yml | 11 ++++++++---
.github/workflows/build-deb-cloudberry.yml | 11 ++++++++---
contrib/btree_gist/expected/bit_optimizer.out | 2 +-
contrib/btree_gist/expected/bytea_optimizer.out | 2 +-
contrib/btree_gist/expected/cash_optimizer.out | 2 +-
contrib/btree_gist/expected/char_optimizer.out | 2 +-
contrib/btree_gist/expected/date_optimizer.out | 2 +-
contrib/btree_gist/expected/enum_optimizer.out | 2 +-
contrib/btree_gist/expected/float4_optimizer.out | 2 +-
contrib/btree_gist/expected/float8_optimizer.out | 2 +-
contrib/btree_gist/expected/inet_optimizer.out | 4 ++--
contrib/btree_gist/expected/int2_optimizer.out | 2 +-
contrib/btree_gist/expected/int4_optimizer.out | 2 +-
contrib/btree_gist/expected/int8_optimizer.out | 2 +-
contrib/btree_gist/expected/interval_optimizer.out | 4 ++--
contrib/btree_gist/expected/macaddr8_optimizer.out | 2 +-
contrib/btree_gist/expected/macaddr_optimizer.out | 2 +-
contrib/btree_gist/expected/not_equal_optimizer.out | 2 +-
contrib/btree_gist/expected/numeric_optimizer.out | 2 +-
contrib/btree_gist/expected/text_optimizer.out | 2 +-
contrib/btree_gist/expected/time_optimizer.out | 2 +-
contrib/btree_gist/expected/timestamp_optimizer.out | 2 +-
contrib/btree_gist/expected/timestamptz_optimizer.out | 2 +-
contrib/btree_gist/expected/varbit_optimizer.out | 2 +-
contrib/pgstattuple/expected/pgstattuple.out | 15 +++++++++------
25 files changed, 49 insertions(+), 36 deletions(-)
diff --git a/.github/workflows/build-cloudberry.yml
b/.github/workflows/build-cloudberry.yml
index 76721d395ee..dcad89f30cb 100644
--- a/.github/workflows/build-cloudberry.yml
+++ b/.github/workflows/build-cloudberry.yml
@@ -289,14 +289,19 @@ jobs:
"contrib/amcheck:installcheck",
"contrib/citext:installcheck",
"contrib/btree_gin:installcheck",
+ "contrib/btree_gist:installcheck",
+ "contrib/dblink:installcheck",
+ "contrib/dict_int:installcheck",
+ "contrib/dict_xsyn:installcheck",
+ "contrib/extprotocol:installcheck",
"contrib/file_fdw:installcheck",
"contrib/formatter_fixedwidth:installcheck",
- "contrib/extprotocol:installcheck",
- "contrib/dblink:installcheck",
+ "contrib/hstore:installcheck",
+ "contrib/indexscan:installcheck",
"contrib/pg_trgm:installcheck",
"contrib/indexscan:installcheck",
- "contrib/hstore:installcheck",
"contrib/pgcrypto:installcheck",
+ "contrib/pgstattuple:installcheck",
"contrib/tablefunc:installcheck",
"contrib/passwordcheck:installcheck",
"contrib/pg_buffercache:installcheck",
diff --git a/.github/workflows/build-deb-cloudberry.yml
b/.github/workflows/build-deb-cloudberry.yml
index 2e87b8aa948..5b4dc549b06 100644
--- a/.github/workflows/build-deb-cloudberry.yml
+++ b/.github/workflows/build-deb-cloudberry.yml
@@ -228,14 +228,19 @@ jobs:
"contrib/amcheck:installcheck",
"contrib/citext:installcheck",
"contrib/btree_gin:installcheck",
+ "contrib/btree_gist:installcheck",
+ "contrib/dblink:installcheck",
+ "contrib/dict_int:installcheck",
+ "contrib/dict_xsyn:installcheck",
+ "contrib/extprotocol:installcheck",
"contrib/file_fdw:installcheck",
"contrib/formatter_fixedwidth:installcheck",
- "contrib/extprotocol:installcheck",
- "contrib/dblink:installcheck",
+ "contrib/hstore:installcheck",
+ "contrib/indexscan:installcheck",
"contrib/pg_trgm:installcheck",
"contrib/indexscan:installcheck",
- "contrib/hstore:installcheck",
"contrib/pgcrypto:installcheck",
+ "contrib/pgstattuple:installcheck",
"contrib/tablefunc:installcheck",
"contrib/passwordcheck:installcheck",
"contrib/pg_buffercache:installcheck",
diff --git a/contrib/btree_gist/expected/bit_optimizer.out
b/contrib/btree_gist/expected/bit_optimizer.out
index e4eff0ede1f..16ea5206989 100644
--- a/contrib/btree_gist/expected/bit_optimizer.out
+++ b/contrib/btree_gist/expected/bit_optimizer.out
@@ -74,6 +74,6 @@ SELECT a FROM bittmp WHERE a BETWEEN '1000000' and '1000001';
-> Index Scan using bitidx on bittmp
Index Cond: ((a >= '1000000'::"bit") AND (a <= '1000001'::"bit"))
Filter: ((a >= '1000000'::"bit") AND (a <= '1000001'::"bit"))
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(5 rows)
diff --git a/contrib/btree_gist/expected/bytea_optimizer.out
b/contrib/btree_gist/expected/bytea_optimizer.out
index f5bdcf10d81..9577112dc0b 100644
--- a/contrib/btree_gist/expected/bytea_optimizer.out
+++ b/contrib/btree_gist/expected/bytea_optimizer.out
@@ -81,7 +81,7 @@ SELECT a FROM byteatmp where a > 'ffa'::bytea;
-> Index Scan using byteaidx on byteatmp
Index Cond: (a > '\x666661'::bytea)
Filter: (a > '\x666661'::bytea)
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(5 rows)
SELECT a FROM byteatmp where a > 'ffa'::bytea;
diff --git a/contrib/btree_gist/expected/cash_optimizer.out
b/contrib/btree_gist/expected/cash_optimizer.out
index 3eaa66958ea..171dec7e511 100644
--- a/contrib/btree_gist/expected/cash_optimizer.out
+++ b/contrib/btree_gist/expected/cash_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '21472.79' FROM moneytmp ORDER BY a <->
'21472.79' LIMIT 3;
-> Result
-> Gather Motion 3:1 (slice1; segments: 3)
-> Seq Scan on moneytmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '21472.79' FROM moneytmp ORDER BY a <-> '21472.79' LIMIT 3;
diff --git a/contrib/btree_gist/expected/char_optimizer.out
b/contrib/btree_gist/expected/char_optimizer.out
index 2b312df8b19..694a197be22 100644
--- a/contrib/btree_gist/expected/char_optimizer.out
+++ b/contrib/btree_gist/expected/char_optimizer.out
@@ -74,7 +74,7 @@ SELECT * FROM chartmp WHERE a BETWEEN '31a' AND '31c';
-> Index Scan using charidx on chartmp
Index Cond: ((a >= '31a'::bpchar) AND (a <= '31c'::bpchar))
Filter: ((a >= '31a'::bpchar) AND (a <= '31c'::bpchar))
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(5 rows)
SELECT * FROM chartmp WHERE a BETWEEN '31a' AND '31c';
diff --git a/contrib/btree_gist/expected/date_optimizer.out
b/contrib/btree_gist/expected/date_optimizer.out
index c634639a4bb..a77041f847f 100644
--- a/contrib/btree_gist/expected/date_optimizer.out
+++ b/contrib/btree_gist/expected/date_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <->
'2001-02-13' LIMIT 3;
-> Sort
Sort Key: ((a <-> '02-13-2001'::date))
-> Seq Scan on datetmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '2001-02-13' FROM datetmp ORDER BY a <-> '2001-02-13' LIMIT 3;
diff --git a/contrib/btree_gist/expected/enum_optimizer.out
b/contrib/btree_gist/expected/enum_optimizer.out
index 4f57069c301..118676d163a 100644
--- a/contrib/btree_gist/expected/enum_optimizer.out
+++ b/contrib/btree_gist/expected/enum_optimizer.out
@@ -87,6 +87,6 @@ SELECT count(*) FROM enumtmp WHERE a >= 'g'::rainbow;
-> Index Scan using enumidx on enumtmp
Index Cond: (a >= 'g'::rainbow)
Filter: (a >= 'g'::rainbow)
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(6 rows)
diff --git a/contrib/btree_gist/expected/float4_optimizer.out
b/contrib/btree_gist/expected/float4_optimizer.out
index 94e24a790b4..cc40e9bd1ae 100644
--- a/contrib/btree_gist/expected/float4_optimizer.out
+++ b/contrib/btree_gist/expected/float4_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '-179.0' FROM float4tmp ORDER BY a <->
'-179.0' LIMIT 3;
-> Sort
Sort Key: ((a <-> '-179'::real))
-> Seq Scan on float4tmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '-179.0' FROM float4tmp ORDER BY a <-> '-179.0' LIMIT 3;
diff --git a/contrib/btree_gist/expected/float8_optimizer.out
b/contrib/btree_gist/expected/float8_optimizer.out
index 0a4e25a4af4..1bd96c44d3b 100644
--- a/contrib/btree_gist/expected/float8_optimizer.out
+++ b/contrib/btree_gist/expected/float8_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '-1890.0' FROM float8tmp ORDER BY a <->
'-1890.0' LIMIT 3;
-> Sort
Sort Key: ((a <-> '-1890'::double precision))
-> Seq Scan on float8tmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '-1890.0' FROM float8tmp ORDER BY a <-> '-1890.0' LIMIT 3;
diff --git a/contrib/btree_gist/expected/inet_optimizer.out
b/contrib/btree_gist/expected/inet_optimizer.out
index c694bae65e4..e6bff65a2bf 100644
--- a/contrib/btree_gist/expected/inet_optimizer.out
+++ b/contrib/btree_gist/expected/inet_optimizer.out
@@ -75,7 +75,7 @@ SELECT count(*) FROM inettmp WHERE a =
'89.225.196.191'::inet;
-> Index Scan using inetidx on inettmp
Index Cond: (a = '89.225.196.191'::inet)
Filter: (a = '89.225.196.191'::inet)
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(6 rows)
SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet;
@@ -96,7 +96,7 @@ SELECT count(*) FROM inettmp WHERE a =
'89.225.196.191'::inet;
-> Index Scan using inettmp_a_a1_idx on inettmp
Index Cond: (a = '89.225.196.191'::inet)
Filter: (a = '89.225.196.191'::inet)
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(6 rows)
SELECT count(*) FROM inettmp WHERE a = '89.225.196.191'::inet;
diff --git a/contrib/btree_gist/expected/int2_optimizer.out
b/contrib/btree_gist/expected/int2_optimizer.out
index b659ba51578..fdfc859097b 100644
--- a/contrib/btree_gist/expected/int2_optimizer.out
+++ b/contrib/btree_gist/expected/int2_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '237' FROM int2tmp ORDER BY a <-> '237' LIMIT
3;
-> Sort
Sort Key: ((a <-> '237'::smallint))
-> Seq Scan on int2tmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '237' FROM int2tmp ORDER BY a <-> '237' LIMIT 3;
diff --git a/contrib/btree_gist/expected/int4_optimizer.out
b/contrib/btree_gist/expected/int4_optimizer.out
index ab22e4b0c14..67107e63bfa 100644
--- a/contrib/btree_gist/expected/int4_optimizer.out
+++ b/contrib/btree_gist/expected/int4_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '237' FROM int4tmp ORDER BY a <-> '237' LIMIT
3;
-> Sort
Sort Key: ((a <-> 237))
-> Seq Scan on int4tmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '237' FROM int4tmp ORDER BY a <-> '237' LIMIT 3;
diff --git a/contrib/btree_gist/expected/int8_optimizer.out
b/contrib/btree_gist/expected/int8_optimizer.out
index 1dad0688e22..ba8e21135e8 100644
--- a/contrib/btree_gist/expected/int8_optimizer.out
+++ b/contrib/btree_gist/expected/int8_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '464571291354841' FROM int8tmp ORDER BY a <->
'464571291354841'
-> Sort
Sort Key: ((a <-> '464571291354841'::bigint))
-> Seq Scan on int8tmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '464571291354841' FROM int8tmp ORDER BY a <->
'464571291354841' LIMIT 3;
diff --git a/contrib/btree_gist/expected/interval_optimizer.out
b/contrib/btree_gist/expected/interval_optimizer.out
index 6f80bbb2dae..f5afd17456b 100644
--- a/contrib/btree_gist/expected/interval_optimizer.out
+++ b/contrib/btree_gist/expected/interval_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY
a <-> '199 days 21
-> Sort
Sort Key: ((a <-> '@ 199 days 21 hours 21 mins 23
secs'::interval))
-> Seq Scan on intervaltmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days
21:21:23' LIMIT 3;
@@ -104,7 +104,7 @@ SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER
BY a <-> '199 days 21
-> Sort
Sort Key: ((a <-> '@ 199 days 21 hours 21 mins 23
secs'::interval))
-> Seq Scan on intervaltmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days
21:21:23' LIMIT 3;
diff --git a/contrib/btree_gist/expected/macaddr8_optimizer.out
b/contrib/btree_gist/expected/macaddr8_optimizer.out
index 5b2ae8caf31..25a84f81383 100644
--- a/contrib/btree_gist/expected/macaddr8_optimizer.out
+++ b/contrib/btree_gist/expected/macaddr8_optimizer.out
@@ -74,7 +74,7 @@ SELECT * FROM macaddr8tmp WHERE a <
'02:03:04:05:06:07'::macaddr8;
-> Index Scan using macaddr8idx on macaddr8tmp
Index Cond: (a < '02:03:04:ff:fe:05:06:07'::macaddr8)
Filter: (a < '02:03:04:ff:fe:05:06:07'::macaddr8)
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(5 rows)
SELECT * FROM macaddr8tmp WHERE a < '02:03:04:05:06:07'::macaddr8;
diff --git a/contrib/btree_gist/expected/macaddr_optimizer.out
b/contrib/btree_gist/expected/macaddr_optimizer.out
index b5dff8ac830..e5f4e0602f5 100644
--- a/contrib/btree_gist/expected/macaddr_optimizer.out
+++ b/contrib/btree_gist/expected/macaddr_optimizer.out
@@ -74,7 +74,7 @@ SELECT * FROM macaddrtmp WHERE a <
'02:03:04:05:06:07'::macaddr;
-> Index Scan using macaddridx on macaddrtmp
Index Cond: (a < '02:03:04:05:06:07'::macaddr)
Filter: (a < '02:03:04:05:06:07'::macaddr)
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(5 rows)
SELECT * FROM macaddrtmp WHERE a < '02:03:04:05:06:07'::macaddr;
diff --git a/contrib/btree_gist/expected/not_equal_optimizer.out
b/contrib/btree_gist/expected/not_equal_optimizer.out
index 579f92f0982..e99a1155ea0 100644
--- a/contrib/btree_gist/expected/not_equal_optimizer.out
+++ b/contrib/btree_gist/expected/not_equal_optimizer.out
@@ -16,7 +16,7 @@ EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <>
'2009-01-01' AND b <> 10.7;
Gather Motion 3:1 (slice1; segments: 3)
-> Seq Scan on test_ne
Filter: ((a <> 'Thu Jan 01 00:00:00 2009'::timestamp without time
zone) AND (b <> 10.7))
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(4 rows)
SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
diff --git a/contrib/btree_gist/expected/numeric_optimizer.out
b/contrib/btree_gist/expected/numeric_optimizer.out
index 3edf30fee0a..41c4996c06f 100644
--- a/contrib/btree_gist/expected/numeric_optimizer.out
+++ b/contrib/btree_gist/expected/numeric_optimizer.out
@@ -199,7 +199,7 @@ SELECT * FROM numerictmp WHERE a BETWEEN 1 AND 300 ORDER BY
a;
-> Index Scan using numericidx on numerictmp
Index Cond: ((a >= '1'::numeric) AND (a <= '300'::numeric))
Filter: ((a >= '1'::numeric) AND (a <= '300'::numeric))
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(8 rows)
SELECT * FROM numerictmp WHERE a BETWEEN 1 AND 300 ORDER BY a;
diff --git a/contrib/btree_gist/expected/text_optimizer.out
b/contrib/btree_gist/expected/text_optimizer.out
index 9651b9d231d..76a2c86337b 100644
--- a/contrib/btree_gist/expected/text_optimizer.out
+++ b/contrib/btree_gist/expected/text_optimizer.out
@@ -81,7 +81,7 @@ SELECT * FROM texttmp WHERE a BETWEEN '31a' AND '31c';
-> Index Scan using textidx on texttmp
Index Cond: ((a >= '31a'::text) AND (a <= '31c'::text))
Filter: ((a >= '31a'::text) AND (a <= '31c'::text))
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(5 rows)
SELECT * FROM texttmp WHERE a BETWEEN '31a' AND '31c';
diff --git a/contrib/btree_gist/expected/time_optimizer.out
b/contrib/btree_gist/expected/time_optimizer.out
index 2005e89bf9f..590ada880b9 100644
--- a/contrib/btree_gist/expected/time_optimizer.out
+++ b/contrib/btree_gist/expected/time_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '10:57:11' FROM timetmp ORDER BY a <->
'10:57:11' LIMIT 3;
-> Sort
Sort Key: ((a <-> '10:57:11'::time without time zone))
-> Seq Scan on timetmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '10:57:11' FROM timetmp ORDER BY a <-> '10:57:11' LIMIT 3;
diff --git a/contrib/btree_gist/expected/timestamp_optimizer.out
b/contrib/btree_gist/expected/timestamp_optimizer.out
index 296bc3e8ac8..1b8e709fe90 100644
--- a/contrib/btree_gist/expected/timestamp_optimizer.out
+++ b/contrib/btree_gist/expected/timestamp_optimizer.out
@@ -82,7 +82,7 @@ SELECT a, a <-> '2004-10-26 08:55:08' FROM timestamptmp ORDER
BY a <-> '2004-10-
-> Sort
Sort Key: ((a <-> 'Tue Oct 26 08:55:08 2004'::timestamp without
time zone))
-> Seq Scan on timestamptmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '2004-10-26 08:55:08' FROM timestamptmp ORDER BY a <->
'2004-10-26 08:55:08' LIMIT 3;
diff --git a/contrib/btree_gist/expected/timestamptz_optimizer.out
b/contrib/btree_gist/expected/timestamptz_optimizer.out
index e2cd3dc89cb..2173c5dca35 100644
--- a/contrib/btree_gist/expected/timestamptz_optimizer.out
+++ b/contrib/btree_gist/expected/timestamptz_optimizer.out
@@ -202,7 +202,7 @@ SELECT a, a <-> '2018-12-18 10:59:54 GMT+2' FROM
timestamptztmp ORDER BY a <-> '
-> Sort
Sort Key: ((a <-> 'Tue Dec 18 04:59:54 2018 PST'::timestamp
with time zone))
-> Seq Scan on timestamptztmp
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(7 rows)
SELECT a, a <-> '2018-12-18 10:59:54 GMT+2' FROM timestamptztmp ORDER BY a <->
'2018-12-18 10:59:54 GMT+2' LIMIT 3;
diff --git a/contrib/btree_gist/expected/varbit_optimizer.out
b/contrib/btree_gist/expected/varbit_optimizer.out
index f73f5688ab1..98727abe44c 100644
--- a/contrib/btree_gist/expected/varbit_optimizer.out
+++ b/contrib/btree_gist/expected/varbit_optimizer.out
@@ -74,6 +74,6 @@ SELECT a FROM bittmp WHERE a BETWEEN '1000000' and '1000001';
-> Index Scan using bitidx on bittmp
Index Cond: ((a >= '1000000'::"bit") AND (a <= '1000001'::"bit"))
Filter: ((a >= '1000000'::"bit") AND (a <= '1000001'::"bit"))
- Optimizer: Pivotal Optimizer (GPORCA)
+ Optimizer: GPORCA
(5 rows)
diff --git a/contrib/pgstattuple/expected/pgstattuple.out
b/contrib/pgstattuple/expected/pgstattuple.out
index 4542d692b55..c8542e75416 100644
--- a/contrib/pgstattuple/expected/pgstattuple.out
+++ b/contrib/pgstattuple/expected/pgstattuple.out
@@ -152,6 +152,8 @@ select pgstatginindex('test_hashidx');
ERROR: relation "test_hashidx" is not a GIN index
-- check that using any of these functions with unsupported relations will fail
create table test_partitioned (a int) partition by range (a);
+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.
create index test_partitioned_index on test_partitioned(a);
-- these should all fail
select pgstattuple('test_partitioned');
@@ -159,9 +161,9 @@ ERROR: "test_partitioned" (partitioned table) is not
supported
select pgstattuple('test_partitioned_index');
ERROR: "test_partitioned_index" (partitioned index) is not supported
select pgstattuple_approx('test_partitioned');
-ERROR: "test_partitioned" is not a table, materialized view, or TOAST table
+ERROR: "test_partitioned" is not a table, directory table, materialized view,
or TOAST table
select pg_relpages('test_partitioned');
-ERROR: "test_partitioned" is not a table, index, materialized view, sequence,
or TOAST table
+ERROR: "test_partitioned" is not a table, directory table, index,
materialized view, sequence, or TOAST table
select pgstatindex('test_partitioned');
ERROR: relation "test_partitioned" is not a btree index
select pgstatginindex('test_partitioned');
@@ -173,9 +175,9 @@ create view test_view as select 1;
select pgstattuple('test_view');
ERROR: "test_view" (view) is not supported
select pgstattuple_approx('test_view');
-ERROR: "test_view" is not a table, materialized view, or TOAST table
+ERROR: "test_view" is not a table, directory table, materialized view, or
TOAST table
select pg_relpages('test_view');
-ERROR: "test_view" is not a table, index, materialized view, sequence, or
TOAST table
+ERROR: "test_view" is not a table, directory table, index, materialized view,
sequence, or TOAST table
select pgstatindex('test_view');
ERROR: relation "test_view" is not a btree index
select pgstatginindex('test_view');
@@ -189,9 +191,9 @@ create foreign table test_foreign_table () server
dummy_server;
select pgstattuple('test_foreign_table');
ERROR: "test_foreign_table" (foreign table) is not supported
select pgstattuple_approx('test_foreign_table');
-ERROR: "test_foreign_table" is not a table, materialized view, or TOAST table
+ERROR: "test_foreign_table" is not a table, directory table, materialized
view, or TOAST table
select pg_relpages('test_foreign_table');
-ERROR: "test_foreign_table" is not a table, index, materialized view,
sequence, or TOAST table
+ERROR: "test_foreign_table" is not a table, directory table, index,
materialized view, sequence, or TOAST table
select pgstatindex('test_foreign_table');
ERROR: relation "test_foreign_table" is not a btree index
select pgstatginindex('test_foreign_table');
@@ -200,6 +202,7 @@ select pgstathashindex('test_foreign_table');
ERROR: "test_foreign_table" is not an index
-- a partition of a partitioned table should work though
create table test_partition partition of test_partitioned for values from (1)
to (100);
+NOTICE: table has parent, setting distribution columns to match parent table
select pgstattuple('test_partition');
pgstattuple
---------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
