Re: BUG #16940: ERROR: unrecognized parameter

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: crimezjp(at)foxmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16940: ERROR: unrecognized parameter
Date: 2021-03-24 00:43:38
Message-ID: YFqLOjd/RQyeNKkU@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2021-03-24 01:40:50 Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.
Previous Message Michael Paquier 2021-03-24 00:32:01 Re: BUG #16927: Postgres can`t access WAL files