The following bug has been logged online:

Bug reference:      3716
Logged by:          Andreas Pflug
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system:   Linux,Windows
Description:        utf8 crash with replace
Details: 

If replace is used with UTF8 client_encoding, searching for a malformed
string, the backend will crash.

SELECT replace('Ärger', chr(195), 'Ae')

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to