Обсуждение: [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

От
Johannes Maurer
Дата:
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.




Portrait
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

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

От
Tom Lane
Дата:
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