pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16940: ERROR:  unrecognized parameter
5+ messages / 3 participants
[nested] [flat]

* BUG #16940: ERROR:  unrecognized parameter
@ 2021-03-23 13:19 PG Bug reporting form <noreply@postgresql.org>
  2021-03-23 14:38 ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 1 reply; 5+ messages in thread

From: PG Bug reporting form @ 2021-03-23 13:19 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: crimezjp@foxmail.com

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16940: ERROR: unrecognized parameter
  2021-03-23 13:19 BUG #16940: ERROR:  unrecognized parameter PG Bug reporting form <noreply@postgresql.org>
@ 2021-03-23 14:38 ` Guillaume Lelarge <guillaume@lelarge.info>
  2021-03-23 14:40   ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 1 reply; 5+ messages in thread

From: Guillaume Lelarge @ 2021-03-23 14:38 UTC (permalink / raw)
  To: crimezjp@foxmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16940: ERROR: unrecognized parameter
  2021-03-23 13:19 BUG #16940: ERROR:  unrecognized parameter PG Bug reporting form <noreply@postgresql.org>
  2021-03-23 14:38 ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
@ 2021-03-23 14:40   ` Guillaume Lelarge <guillaume@lelarge.info>
  2021-03-23 15:26     ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 1 reply; 5+ messages in thread

From: Guillaume Lelarge @ 2021-03-23 14:40 UTC (permalink / raw)
  To: crimezjp@foxmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Le mar. 23 mars 2021 à 15:38, Guillaume Lelarge <guillaume@lelarge.info> a
écrit :

> 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.
>
>
And actually, they are. My bad.


-- 
Guillaume.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16940: ERROR: unrecognized parameter
  2021-03-23 13:19 BUG #16940: ERROR:  unrecognized parameter PG Bug reporting form <noreply@postgresql.org>
  2021-03-23 14:38 ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
  2021-03-23 14:40   ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
@ 2021-03-23 15:26     ` Guillaume Lelarge <guillaume@lelarge.info>
  2021-03-24 00:43       ` Re: BUG #16940: ERROR: unrecognized parameter Michael Paquier <michael@paquier.xyz>
  0 siblings, 1 reply; 5+ messages in thread

From: Guillaume Lelarge @ 2021-03-23 15:26 UTC (permalink / raw)
  To: crimezjp@foxmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Le mar. 23 mars 2021 à 15:40, Guillaume Lelarge <guillaume@lelarge.info> a
écrit :

> Le mar. 23 mars 2021 à 15:38, Guillaume Lelarge <guillaume@lelarge.info>
> a écrit :
>
>> 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.
>>
>>
> And actually, they are. My bad.
>
>
You can't use storage parameters on partitioned tables, as the fine docs
say: "Specifying these parameters for partitioned tables is not supported,
but you may specify them for individual leaf partitions." See
https://www.postgresql.org/docs/13/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS
.

Hope I'm not wrong this time :)


-- 
Guillaume.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16940: ERROR: unrecognized parameter
  2021-03-23 13:19 BUG #16940: ERROR:  unrecognized parameter PG Bug reporting form <noreply@postgresql.org>
  2021-03-23 14:38 ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
  2021-03-23 14:40   ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
  2021-03-23 15:26     ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
@ 2021-03-24 00:43       ` Michael Paquier <michael@paquier.xyz>
  0 siblings, 0 replies; 5+ messages in thread

From: Michael Paquier @ 2021-03-24 00:43 UTC (permalink / raw)
  To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: crimezjp@foxmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

On Tue, Mar 23, 2021 at 04:26:41PM +0100, Guillaume Lelarge wrote:
> You can't use storage parameters on partitioned tables, as the fine docs
> say: "Specifying these parameters for partitioned tables is not supported,
> but you may specify them for individual leaf partitions." See
> https://www.postgresql.org/docs/13/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS

Partitioned tables have no relation options.  As of reloptions.c:
bytea *
partitioned_table_reloptions(Datum reloptions, bool validate)
{
    /*
     * There are no options for partitioned tables yet, but this is able to do
     * some validation.
     */
   return (bytea *) build_reloptions(reloptions, validate,
                                     RELOPT_KIND_PARTITIONED,
                                     0, NULL, 0);
}
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2021-03-24 00:43 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-23 13:19 BUG #16940: ERROR:  unrecognized parameter PG Bug reporting form <noreply@postgresql.org>
2021-03-23 14:38 ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
2021-03-23 14:40   ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
2021-03-23 15:26     ` Re: BUG #16940: ERROR: unrecognized parameter Guillaume Lelarge <guillaume@lelarge.info>
2021-03-24 00:43       ` Re: BUG #16940: ERROR: unrecognized parameter Michael Paquier <michael@paquier.xyz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox