Re: pg_background (and more parallelism infrastructure patches)

On Wed, Nov 12, 2014 at 11:09 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>
> On Wed, Nov 12, 2014 at 11:36 AM, Robert Haas <robertmhaas(at)gmail(dot)com>
wrote:
> > On Wed, Nov 12, 2014 at 11:19 AM, Andres Freund <andres(at)2ndquadrant(dot)com>
wrote:
> >> The question is whether the library is actually loaded in that case?
> >> Because that normally only happens early during startup - which is why
> >> it's a PGC_BACKEND guc.
> >
> > It looks like that does not work.
> >
> > [rhaas pgsql]$ PGOPTIONS='-c local_preload_libraries=auto_explain' psql
> > psql (9.5devel)
> > Type "help" for help.
> >
> > rhaas=# select * from pg_background_result(pg_background_launch('show
> > auto_explain.log_min_duration')) as (x text);
> > ERROR: unrecognized configuration parameter
"auto_explain.log_min_duration"
> > CONTEXT: background worker, pid 31316
> >
> > So, there's more to be done here. Rats.
>
> It turned out to be quite simple to fix both problems.
>
> Updated patches attached.
>

Few compilation errors in the patch:
1>contrib\postgres_fdw\postgres_fdw.c(2107): error C2198:
'set_config_option' : too few arguments for call
1>contrib\postgres_fdw\postgres_fdw.c(2111): error C2198:
'set_config_option' : too few arguments for call
1>contrib\postgres_fdw\postgres_fdw.c(2115): error C2198:
'set_config_option' : too few arguments for call
2>contrib\dblink\dblink.c(2983): error C2198: 'set_config_option' : too few
arguments for call

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com