Re: WARNING in parallel index creation. - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: WARNING in parallel index creation.
Date
Msg-id CAH2-Wz=5+8Pi-Kheqf7zECkKf+9gr+zkW61WN58s5UD_m7807g@mail.gmail.com
Whole thread Raw
In response to WARNING in parallel index creation.  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: WARNING in parallel index creation.  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Sun, Mar 11, 2018 at 10:15 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> Then when I create in index, I get a warning:
>
> jjanes=# create index on pgbench_accounts (foobar(filler));
> WARNING:  cannot set parameters during a parallel operation
> WARNING:  cannot set parameters during a parallel operation
>
> If I create the index again within the same session, there is no WARNING.
>
> This only occurs if plperl.on_init is set in the postgresql.conf file.  It
> doesn't seem to matter what it is set to,
> even the empty string triggers the warning.

I wonder why DefineCustomStringVariable() does not set var->reset_val.
We see that within DefineCustomEnumVariable(),
DefineCustomRealVariable(), DefineCustomIntVariable(), etc.

-- 
Peter Geoghegan


pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] Partition-wise aggregation/grouping
Next
From: Andrew Dunstan
Date:
Subject: Re: ALTER TABLE ADD COLUMN fast default