copy command PANIC in --encoding='utf8' createdb option - Mailing list pgsql-bugs

From Sil Lee
Subject copy command PANIC in --encoding='utf8' createdb option
Date
Msg-id 9005e8bb041026190167188fe3@mail.gmail.com
Whole thread Raw
Responses Re: copy command PANIC in --encoding='utf8' createdb option
List pgsql-bugs
I installed PostgreSQL-8.0beta4 on Linux Fedora Core2.

and first I made database test1. and create table t1, copy data from
file 'test.dmp'
$ createdb  test1
CREATE DATABASE

$psql test1
test1=3D> create table t1 (col1 varchar(100));
CREATE TABLE
test1=3D> show client_encoding;
 client_encoding
-----------------
 EUC_KR
(1 row)

and load data from 'test.dmp' file
test1=3D> \copy t1 (col1) from '/tmp/test.dmp'
\.
ERROR:  invalid byte sequence for encoding "EUC_KR": 0xb85f
CONTEXT:  COPY t1, line 1, column col1: "/system/workbin/=EB=93=B1=EB=9D=BD=
=EC=A2=85??.TXT.20040319"
test1=3D>

the test.dmp file is
$ cat test.dmp
/system/workbin/=EB=93=B1=EB=9D=BD=EC=A2=85??.TXT.20040319
$ od -h test.dmp
0000000 732f 7379 6574 2f6d 6f77 6b72 6962 2f6e
0000020 eeb5 f4b6 bec1 5fb8 5fbc 542e 5458 322e
0000040 3030 3034 3133 0a39
0000050

the first cast is good..=20
but second case, creatdb with --encoding=3D'utf8'

$ createdb test1 --encoding=3D'utf8'
CREATE DATABASE

$ psql test1
test1=3D> show client_encoding;
 client_encoding
-----------------
 UNICODE
(1 row)
test1=3D> set client_encoding =3D 'uhc';
SET
test1=3D> \copy t1 (col1) from '/opt/lgsec/dmp/test.dmp'
\.
PANIC:  ERRORDATA_STACK_SIZE exceeded
test1=3D>

^^; postmaster log=20
WARNING:  ignoring unconvertible UHC character 0xb85f
CONTEXT:  COPY t1, line 1: "/system/workbin/=EB=93=B1=EB=9D=BD=EC=A2=85??.T=
XT.20040319"
WARNING:  ignoring unconvertible UTF-8 character 0xeeb6f4
CONTEXT:  COPY t1, line 1: "/system/workbin/=EB=93=B1=EB=9D=BD=EC=A2=85??.T=
XT.20040319"
WARNING:  ignoring unconvertible UTF-8 character 0xeeb6f4
CONTEXT:  COPY t1, line 1: "/system/workbin/=EB=93=B1=EB=9D=BD=EC=A2=85??.T=
XT.20040319"
WARNING:  ignoring unconvertible UTF-8 character 0xeeb6f4
CONTEXT:  COPY t1, line 1: "/system/workbin/=EB=93=B1=EB=9D=BD=EC=A2=85??.T=
XT.20040319"
WARNING:  ignoring unconvertible UTF-8 character 0xeeb6f4
CONTEXT:  COPY t1, line 1: "/system/workbin/=EB=93=B1=EB=9D=BD=EC=A2=85??.T=
XT.20040319"
PANIC:  ERRORDATA_STACK_SIZE exceeded
STATEMENT:  COPY t1 (col1) FROM STDIN
LOG:  server process (PID 23319) was terminated by signal 6
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2004-10-27 10:39:57 KST
LOG:  checkpoint record is at 0/CEB2D04
LOG:  redo record is at 0/CEB2D04; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 3151; next OID: 1794894
LOG:  database system was not properly shut down; automatic recovery in pro=
gress
LOG:  record with zero length at 0/CEB2D40
LOG:  redo is not required
LOG:  database system is ready


It may be encoding problem ... but i can' slove it.. sorry..
How can I copy from the test.dmp file..?

thank you very much in advance! have a nice day
everyone!

pgsql-bugs by date:

Previous
From: "Thomas Wegner"
Date:
Subject: Dropdb, Win32 Problem
Next
From: Jan Wieck
Date:
Subject: Re: [Slony1-general] Thread-safety detection on HP-UX