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:
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 ba baa
Erik Rijkers e...@xs4all.nl 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