Re: Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Johannes Maurer <johannes(dot)maurer(at)gruberreisen(dot)at>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42
Date: 2017-10-06 14:27:12
Message-ID: 5365.1507300032@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Johannes Maurer <johannes(dot)maurer(at)gruberreisen(dot)at> writes:
> when running the following command
> select regexp_replace('##text1##', '^##', '(##([^#]*?\.|)');

> I get the followin error message:
> FEHLER: invalid cache ID: 42
> Where: paralleler Arbeitsprozess

Works for me, even after setting force_parallel_mode=1. You'll need
to provide more context. For starters, what nondefault settings are
you using?

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-10-06 14:48:51 Re: BUG #14844: Failure/Duplicate key value with ALTER DATABASE set search_path
Previous Message Johannes Maurer 2017-10-06 13:53:00 Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42