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