Обсуждение: BUG #14028: FATAL: cannot perform encoding conversion outside a transaction
BUG #14028: FATAL: cannot perform encoding conversion outside a transaction
От
srivathson.k@zohocorp.com
Дата:
The following bug has been logged on the website: Bug reference: 14028 Logged by: Srivathson KK Email address: srivathson.k@zohocorp.com PostgreSQL version: 9.4.0 Operating system: Windows Server 2008 R2 - Korean Description: I m trying to install PostgreSQL server 9.4.0 in Korean Windows Server 2008 R2 operating system. I performed initdb using the command (initdb.exe -D ..\data -U postgres --no-locale -E UTF8). I m trying to start database server using the command (pg_ctl.exe -D ..\data start). I ended up with the following error. FATAL: cannot perform encoding conversion outside a transaction
srivathson.k@zohocorp.com writes: > Bug reference: 14028 > Logged by: Srivathson KK > Email address: srivathson.k@zohocorp.com > PostgreSQL version: 9.4.0 > Operating system: Windows Server 2008 R2 - Korean > Description: > I m trying to install PostgreSQL server 9.4.0 in Korean Windows Server 2008 > R2 operating system. > I performed initdb using the command (initdb.exe -D ..\data -U postgres > --no-locale -E UTF8). > I m trying to start database server using the command (pg_ctl.exe -D ..\data > start). I ended up with the following error. > FATAL: cannot perform encoding conversion outside a transaction The release notes for 9.4.5 mention a bug fix that seems to match this symptom. Please update. regards, tom lane
Re: BUG #14028: FATAL: cannot perform encoding conversion outside a transaction
От
Srivathson KK
Дата:
Thanks Tom, Its working! Btw, may I know why it is still in Todo list? Regards, Srivathson. ---- On Fri, 18 Mar 2016 05:06:24 +0530 Tom Lane <tgl@sss.pgh.pa.us>wrote ---- srivathson.k@zohocorp.com writes: > Bug reference: 14028 > Logged by: Srivathson KK > Email address: srivathson.k@zohocorp.com > PostgreSQL version: 9.4.0 > Operating system: Windows Server 2008 R2 - Korean > Description: > I m trying to install PostgreSQL server 9.4.0 in Korean Windows Server 2008 > R2 operating system. > I performed initdb using the command (initdb.exe -D ..\data -U postgres > --no-locale -E UTF8). > I m trying to start database server using the command (pg_ctl.exe -D ..\data > start). I ended up with the following error. > FATAL: cannot perform encoding conversion outside a transaction The release notes for 9.4.5 mention a bug fix that seems to match this symptom. Please update. regards, tom lane
On Mon, Mar 21, 2016 at 04:32:43PM +0530, Srivathson KK wrote: > Btw, may I know why it is still in Todo list? I assume you mean this TODO item: |Windows: Cache MessageEncoding conversion for use outside transactions * http://www.postgresql.org/message-id/20150812055719.GA1945333@tornado.leadboat.com The changes in 9.4.5 stopped the "cannot perform encoding conversion outside a transaction" errors and fixed things completely for Korean-locale databases. For a database encoding having no Windows code page, such LATIN8, we still make mojibake with a non-ASCII message written outside a transaction. The TODO item would fix that.