Re: Bug in 'query tool'

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of YourSoft
> Sent: 22 May 2006 15:15
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Bug in 'query tool'
> 
> Dear List,
> 
> I found an other bug related to special characters.
> Try insert the following query:
> select translate(s2, 'ÁÉÍÓÖŐÜŰÚ', 'áéíóöőüűú'); save the 
> query into file. You will get a 0 byte length file.

What version of PostgreSQL? I get the following for that query in 8.1.4:

ERROR:  character 0xc590 of encoding "UTF8" has no equivalent in "LATIN1"

Though 8.1.4 does include *serious* hardening of the encoding validation routines.

Regards, Dave.