"Erik Rijkers" writes:
> On Wed, September 25, 2013 09:33, Marc Mamin wrote:
>> This regexp call freezes with almost 100% CPU usage, so I guess it creates
>> an infinite loop.
>> cic_db=# select regexp_matches ('aa bb aa ba baa x','(^((?!aa)))+','gx');
I poked into this a bit and decided that it
On Wed, September 25, 2013 09:33, Marc Mamin wrote:
> Hi,
>
> This regexp call freezes with almost 100% CPU usage, so I guess it creates an
> infinite loop.
>
> With Postgres 9.1 on Linux, I can kill the backend cleanly and get following
> message:
>
> cic_db=# select regexp_matches ('aa bb aa b
Hi,
This regexp call freezes with almost 100% CPU usage, so I guess it creates an
infinite loop.
With Postgres 9.1 on Linux, I can kill the backend cleanly and get following
message:
cic_db=# select regexp_matches ('aa bb aa ba baa x','(^((?!aa)))+','gx');
ERROR: invalid regular expression: