Thread: [BUGS] Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42
[BUGS] Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42
From
Johannes Maurer
Date:
Hi,
when running the following command
select regexp_replace('##text1##', '^##', '(##([^#]*?\.|)');
I get the followin error message:
FEHLER: invalid cache ID: 42
Where: paralleler Arbeitsprozess
FEHLER: invalid cache ID: 42
Where: paralleler Arbeitsprozess
It used to work in Postgres 9.5 and 9.6.
![]() | Mit sonnigen Grüßen Johannes Maurer - BI Analyst GRUBER Touristik GmbH HG Wien FN 214982a, ATU-53633803 8055 Graz, Puchstraße 176, Tel.: +43-316-7089-4225, Fax: -84225 |
Johannes Maurer <johannes.maurer@gruberreisen.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs