| 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: | Whole Thread | Raw Message | 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
| 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 |