BUG #16940: ERROR: unrecognized parameter

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: crimezjp(at)foxmail(dot)com
Subject: BUG #16940: ERROR: unrecognized parameter
Date: 2021-03-23 13:19:44
Message-ID: 16940-3b391bb645179f33@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16940
Logged by: Zhu Ethan
Email address: crimezjp(at)foxmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Guillaume Lelarge 2021-03-23 14:38:52 Re: BUG #16940: ERROR: unrecognized parameter
Previous Message Ярослав Пашинский 2021-03-23 09:49:32 Re: BUG #16927: Postgres can`t access WAL files