Re: WARNING in parallel index creation.

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WARNING in parallel index creation.
Date: 2018-03-13 03:44:01
Message-ID: CAH2-Wz=5+8Pi-Kheqf7zECkKf+9gr+zkW61WN58s5UD_m7807g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Mar 11, 2018 at 10:15 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2018-03-13 04:10:16 Re: ALTER TABLE ADD COLUMN fast default
Previous Message Ashutosh Bapat 2018-03-13 03:42:49 Re: [HACKERS] Partition-wise aggregation/grouping