Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42
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
[ mailto:johannes.maurer@gruberreisen.at | johannes.maurer@gruberreisen.at ] <> [ https://www.gruberreisen.at/ | www.gruberreisen.at ] <> [ https://facebook.com/GRUBERreisen | facebook.com/GRUBERreisen ]
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