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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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
* /messages/by-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.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs