Re: [HACKERS] invalid regexp crashes the server on windows or 9.3

2013-09-25 Thread Tom Lane
"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

Re: [HACKERS] invalid regexp crashes the server on windows or 9.3

2013-09-25 Thread Erik Rijkers
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

[HACKERS] invalid regexp crashes the server on windows or 9.3

2013-09-25 Thread Marc Mamin
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: