Re: possible replace() bug - postgres 7.3.1

From: Joe Conway <mail(at)joeconway(dot)com>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Ryan Mahoney <ryan(at)paymentalliance(dot)net>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: possible replace() bug - postgres 7.3.1
Date: 2003-11-09 22:38:13
Message-ID: 3FAEC1D5.4090503@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hannu Krosing wrote:
> Ryan Mahoney kirjutas N, 06.11.2003 kell 23:03:
>>I am running PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96
> what does just
>
> SELECT replace(data, '\'', '\'\'')
> FROM temp_sales_lead
> ORDER BY id, row LIMIT 10;
>
> produce ?

There was a bug in replace(), fixed by Tom in 7.3.3 I think (for sure by
7.3.4). If you have any embedded "%" characters in data, it would
trigger the bug. Try upgrading to 7.3.4.

HTH,

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-11-09 22:59:15 Re: Problem in restoring data
Previous Message Hannu Krosing 2003-11-09 21:51:25 Re: possible replace() bug - postgres 7.3.1

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2003-11-09 22:43:17 Re: OSR5: Passes without the setsockopt() calls...
Previous Message Larry Rosenman 2003-11-09 22:18:43 Re: OSR5: Passes without the setsockopt() calls...