Обсуждение: BUG #14028: FATAL: cannot perform encoding conversion outside a transaction

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

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.