Error for WITH options on partitioned tables

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Error for WITH options on partitioned tables
Дата
Msg-id CANbhV-H=eZ9kTR9mUgKGK0Qv9uXP=U+dQg3rinQHfTdFMhBA2A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Error for WITH options on partitioned tables  (Japin Li <japinli@hotmail.com>)
Список pgsql-hackers
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/

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Switching XLog source from archive to streaming when primary available
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: SUBTRANS: Minimizing calls to SubTransSetParent()