Re: BUG #5800: "corrupted" error messages (encoding problem ?)

[Please keep messages on the mailing list]

Hi,

I don't see anything there that gives me any ideas. Anyone else have any ideas?

2011/1/7 Génération Amiga <genamiga(at)brutele(dot)be>:
> Hello Dave,
>
> Here are the result of "\! set" on the servers and I still have W7-32 and W7-64 (WinXP died)
> **************
> W7-64 and PG9-64
> **************
> postgres=# \! set;
> =::=::\
> =C:=C:\Program Files\PostgreSQL\9.0\scripts
> ALLUSERSPROFILE=C:\ProgramData
> APPDATA=C:\Users\Carlo\AppData\Roaming
> CLIENTENCODING_JP=0
> CommonProgramFiles=C:\Program Files\Common Files
> CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
> CommonProgramW6432=C:\Program Files\Common Files
> COMPUTERNAME=WIN7-64
> ComSpec=C:\Windows\system32\cmd.exe
> database=postgres
> FP_NO_HOST_CHECK=NO
> HOMEDRIVE=C:
> HOMEPATH=\Users\Carlo
> LOCALAPPDATA=C:\Users\Carlo\AppData\Local
> LOGONSERVER=\\WIN7-64
> NUMBER_OF_PROCESSORS=2
> OS=Windows_NT
> Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\
> PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
> PGLOCALEDIR=C:/Program Files/PostgreSQL/9.0/share/locale
> PGSYSCONFDIR=C:/Program Files/PostgreSQL/9.0/etc
> port=5432
> PROCESSOR_ARCHITECTURE=AMD64
> PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 15 Stepping 6, GenuineIntel
> PROCESSOR_LEVEL=6
> PROCESSOR_REVISION=0f06
> ProgramData=C:\ProgramData
> ProgramFiles=C:\Program Files
> ProgramFiles(x86)=C:\Program Files (x86)
> ProgramW6432=C:\Program Files
> PROMPT=$P$G
> PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
> PUBLIC=C:\Users\Public
> server=localhost
> SESSIONNAME=Console
> SystemDrive=C:
> SystemRoot=C:\Windows
> TEMP=C:\Users\Carlo\AppData\Local\Temp
> TMP=C:\Users\Carlo\AppData\Local\Temp
> USERDOMAIN=WIN7-64
> USERNAME=postgres
> USERPROFILE=C:\Users\Carlo
> windir=C:\Windows
> postgres=#
>
> **************
> W7-32 and PG9-32
> **************
> postgres=# \! set;
> =::=::\
> =C:=C:\Program Files\PostgreSQL\9.0\scripts
> ALLUSERSPROFILE=C:\ProgramData
> APPDATA=C:\Users\Carlo\AppData\Roaming
> CLIENTENCODING_JP=0
> CommonProgramFiles=C:\Program Files\Common Files
> COMPUTERNAME=WIN7-32
> ComSpec=C:\Windows\system32\cmd.exe
> database=postgres
> FP_NO_HOST_CHECK=NO
> HOMEDRIVE=C:
> HOMEPATH=\Users\Carlo
> LOCALAPPDATA=C:\Users\Carlo\AppData\Local
> LOGONSERVER=\\WIN7-32
> NUMBER_OF_PROCESSORS=1
> OS=Windows_NT
> Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\
> PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
> PGLOCALEDIR=C:/Program Files/PostgreSQL/9.0/share/locale
> PGSYSCONFDIR=C:/Program Files/PostgreSQL/9.0/etc
> port=5432
> PROCESSOR_ARCHITECTURE=x86
> PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 4, GenuineIntel
> PROCESSOR_LEVEL=15
> PROCESSOR_REVISION=0204
> ProgramData=C:\ProgramData
> ProgramFiles=C:\Program Files
> PROMPT=$P$G
> PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
> PUBLIC=C:\Users\Public
> server=localhost
> SESSIONNAME=Console
> SystemDrive=C:
> SystemRoot=C:\Windows
> TEMP=C:\Users\Carlo\AppData\Local\Temp
> TMP=C:\Users\Carlo\AppData\Local\Temp
> USERDOMAIN=Win7-32
> USERNAME=postgres
> USERPROFILE=C:\Users\Carlo
> windir=C:\Windows
> postgres=#
> ***********************************************
> I can send you whatever you need, I don't touch anything to those servers. I use them only for testing and I have image backups.
>
> Best regards.
>
> Curatolo Carlo
>
> = = = = = = = = Message d'origine du 2011-01-07 à 11:41:30 = = = = = = = =
> On Tue, Dec 21, 2010 at 3:47 PM, Carlo Curatolo <genamiga(at)brutele(dot)be> wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference:      5800
>> Logged by:          Carlo Curatolo
>> Email address:      genamiga(at)brutele(dot)be
>> PostgreSQL version: 9.0.2 64bits
>> Operating system:   Windows 7 64bits
>> Description:        "corrupted" error messages (encoding problem ?)
>> Details:
>>
>> On a new PC I install only Windows (French) and PosgreSQL 9.0.2 with default
>> parameters and without creating any object.
>>
>> Example of "corrupted" error messages that occurs on several client software
>> (my own Java program, dbVisualizer, EMS SQL Manager)
>>
>> [Error Code: 0, SQL State: 42601]  ERREUR: erreur de syntaxe � la fin de
>> l'entr�e
>>
>> Test 1 : Windows 7 64 bits and PosgreSQL 9.0.2 64 bits
>>
>> ... the problem occurs
>>
>> Test 2 : Windows 7 64 bits and PosgreSQL 9.0.2 32 bits
>>
>> ... the problem occurs
>>
>> Test 3 : Windows 7 32 bits and PosgreSQL 9.0.2 32 bits
>>
>> ... NO problem, the error message is correct
>> [Error Code: 0, SQL State: 42601]  ERREUR: erreur de syntaxe à la fin de
>> l'entrée
>>
>> This issue occurs only when PostgreSQL 9.0.2 is installed on Windows 7 64
>> bits...
> FYI, we've been investigating this, however, whilst we can reproduce
> the same issue, we see it in different circumstances which conflict
> with yours:
> You reported:
> 64 bit OS, 64 bit PG - corruption
> 64 bit OS, 32 bit PG - corruption
> 32 bit OS, 32 bit PG - OK
> We see:
> 64 bit OS, 64 bit PG - OK
> 64 bit OS, 32 bit PG - corruption
> 32 bit OS, 32 bit PG - corruption
> That implies to us that this is something environmental, rather than a
> build or installer bug (between us, both installers work correctly on
> their native platforms).
> What does the environment look like on both of your servers? Try
> running "\! set" from a psql session in each.
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
> -----
> Aucun virus trouvé dans ce message.
> Analyse effectuée par AVG - www.avg.fr
> Version: 10.0.1191 / Base de données virale: 1435/3364 - Date: 06/01/2011
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company