BUG #5531: REGEXP_ REPLACE causes connection drop

From: "Ola Sergatchov" <ola_sergatchov(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5531: REGEXP_ REPLACE causes connection drop
Date: 2010-06-30 01:52:38
Message-ID: 201006300152.o5U1qc3X035449@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5531
Logged by: Ola Sergatchov
Email address: ola_sergatchov(at)hotmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marcel Asio 2010-06-30 06:06:30 Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"
Previous Message Oliver Jowett 2010-06-30 01:10:33 Re: [JDBC] JDBC: 2 bugs: Getting a smallint array actually gets an integer array and return type of a boolean array is bit.