Someone on general list recently complained that the error message
from trying to use options on a partitioned table was misleading,
which it definitely is:

CREATE TABLE parted_col_comment (a int, b text) PARTITION BY LIST (a)
WITH (fillfactor=100);
ERROR:  unrecognized parameter "fillfactor"

Which is verified by patch 001.

Patch 002 replaces this with a more meaningful error message, which
matches our fine manual.
https://www.postgresql.org/docs/current/sql-createtable.html

 ERROR:  cannot specify storage options for a partitioned table
 HINT:  specify storage options on leaf partitions instead

-- 
Simon Riggs                http://www.EnterpriseDB.com/

Attachment: 001_test_options_with_partitioned_table.v1.patch
Description: Binary data

Attachment: 002_better_error_for_options_on_partitioned.v1.patch
Description: Binary data

Reply via email to