The following bug has been logged online:
Bug reference: 5531
Logged by: Ola Sergatchov
Email address: ola_sergatchov@hotmail.com
PostgreSQL version: 8.1.18
Operating system: RedHat Linux 4.1.2-46
Description: REGEXP_ REPLACE causes connection drop
Details:
Passing large string to REGEXP_REPLACE function causes the DB connection to
drop. We executed this function with very large strings (20,000 - 250,000
characters) both from RedHat and PgAdmin and in both cases the function
fails to return and eventually the connection drops. From looking in the
documentation, there is no reference to the maximum size of the string that
his function can process.