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

From Andres Freund
Subject Re: WARNING in parallel index creation.
Date
Msg-id 20180411160231.veb3z6ztt2nza3en@alap3.anarazel.de
Whole thread Raw
In response to Re: WARNING in parallel index creation.  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: WARNING in parallel index creation.
List pgsql-hackers
On 2018-03-12 20:44:01 -0700, Peter Geoghegan wrote:
> 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, have you investigated this any further? This has been an open
item for a while.

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Creation of wiki page for open items of v11
Next
From: Andres Freund
Date:
Subject: Re: es_query_dsa is broken