diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out index 02d0999580..6deeadbfab 100644 --- a/src/test/regress/expected/create_table.out +++ b/src/test/regress/expected/create_table.out @@ -987,6 +987,9 @@ Partition key: LIST (a) Number of partitions: 0 DROP TABLE parted_col_comment; +-- specify options with partitioning +CREATE TABLE parted_col_comment (a int, b text) PARTITION BY LIST (a) WITH (fillfactor=100); +ERROR: unrecognized parameter "fillfactor" -- list partitioning on array type column CREATE TABLE arrlp (a int[]) PARTITION BY LIST (a); CREATE TABLE arrlp12 PARTITION OF arrlp FOR VALUES IN ('{1}', '{2}'); diff --git a/src/test/regress/sql/create_table.sql b/src/test/regress/sql/create_table.sql index 37dac6b5fb..87118800ed 100644 --- a/src/test/regress/sql/create_table.sql +++ b/src/test/regress/sql/create_table.sql @@ -652,6 +652,9 @@ SELECT obj_description('parted_col_comment'::regclass); \d+ parted_col_comment DROP TABLE parted_col_comment; +-- specify options with partitioning +CREATE TABLE parted_col_comment (a int, b text) PARTITION BY LIST (a) WITH (fillfactor=100); + -- list partitioning on array type column CREATE TABLE arrlp (a int[]) PARTITION BY LIST (a); CREATE TABLE arrlp12 PARTITION OF arrlp FOR VALUES IN ('{1}', '{2}');