Re: BUG #5531: REGEXP_ REPLACE causes connection drop - Mailing list pgsql-bugs

Ola Sergatchov wrote:
>
> 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.

Can you show us any relevant entries in the server logs?  FYI, 8.1.18 is
both old for minor and major release.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +