Re: BUG #15726: parallel queries failed ERROR: invalid name syntaxCONTEXT: parallel worker

On Tue, Apr 2, 2019 at 10:59 AM Thomas Munro <thomas.munro@gmail.com> wrote:
> On Tue, Apr 2, 2019 at 12:24 AM PG Bug reporting form
> <noreply@postgresql.org> wrote:
> > default_text_search_config = ''  #default 'pg_catalog.simple'
>
> That causes problems for parallel workers.  The stack looks like this:

> Why is the empty string acceptable to the master but not with
> RestoreGUCState() in a parallel worker?

Because check_TSCurrentConfig() only reports and error if there is an
active transaction.  So you can see this without parallelism like
this:

postgres=# begin;
BEGIN
postgres=# set default_text_search_config = '';
psql: ERROR:  invalid name syntax

I think the short term answer is that you need a better value for
default_text_search_config.  It's unfortunate that this error is
normally hidden, but then jumps out with an incomprehensible message
when you run a parallel query.  Perhaps someone who knows more about
TS than me could comment on whether this should be considered a bug?

-- 
Thomas Munro
https://enterprisedb.com