Re: BUG #16940: ERROR: unrecognized parameter

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: BUG #16940: ERROR: unrecognized parameter
Дата
Msg-id CAECtzeWVGs2JQT5_omZAMgqrZgEC2egSG5naNuCB+-uAnhe_ug@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16940: ERROR: unrecognized parameter  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16940: ERROR: unrecognized parameter  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-bugs
Hi,

Le mar. 23 mars 2021 à 14:31, PG Bug reporting form <noreply@postgresql.org> a écrit :
The following bug has been logged on the website:

Bug reference:      16940
Logged by:          Zhu Ethan
Email address:      crimezjp@foxmail.com
PostgreSQL version: 13.2
Operating system:   Ubuntu 20.04
Description:       

postgres=# CREATE TEMP TABLE IF NOT EXISTS t0(c0 REAL  PRIMARY KEY DEFAULT
(0.7718745), c1 boolean , c2 FLOAT  DEFAULT (0.4103656432464894)) PARTITION
BY RANGE((t0.c0)) WITH (autovacuum_vacuum_cost_delay=84,
autovacuum_freeze_table_age=797746365, autovacuum_enabled=0,
parallel_workers=736, autovacuum_vacuum_cost_limit=1031, fillfactor=89,
autovacuum_freeze_min_age=296312345, autovacuum_analyze_threshold=542044648,
autovacuum_freeze_max_age=1616982866) ON COMMIT DROP ;
ERROR:  22023: unrecognized parameter "autovacuum_vacuum_cost_delay"
LOCATION:  parseRelOptionsInternal, reloptions.c:1445

postgres=# CREATE TEMPORARY TABLE IF NOT EXISTS t0(c0 boolean  DEFAULT
((to_hex('0.9439359616884709')) IN (family('255.150.15.43')))) PARTITION BY
HASH((t0.c0)oidvector_ops) WITH (autovacuum_freeze_min_age=404730583,
fillfactor=91, autovacuum_vacuum_scale_factor=1.0E-5,
autovacuum_vacuum_cost_delay=64, autovacuum_freeze_max_age=434090753,
autovacuum_analyze_threshold=1645614243, parallel_workers=74,
autovacuum_enabled=1, autovacuum_analyze_scale_factor=0.2) ON COMMIT DROP
;
ERROR:  22023: unrecognized parameter "autovacuum_freeze_min_age"
LOCATION:  parseRelOptionsInternal, reloptions.c:1445


Not a bug. autovacuum_vacuum_cost_delay and autovacuum_freeze_min_age are not table storage parameters.


--
Guillaume.

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16940: ERROR: unrecognized parameter
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: BUG #16940: ERROR: unrecognized parameter