Skip site navigation (1) Skip section navigation (2)

copy command PANIC in --encoding='utf8' createdb option

From: Sil Lee <leesil(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: copy command PANIC in --encoding='utf8' createdb option
Date: 2004-10-27 02:01:57
Message-ID: 9005e8bb041026190167188fe3@mail.gmail.com (view raw or flat)
Thread:
Lists: 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=> create table t1 (col1 varchar(100));
CREATE TABLE
test1=> show client_encoding;
 client_encoding
-----------------
 EUC_KR
(1 row)

and load data from 'test.dmp' file
test1=> \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/등락종??.TXT.20040319"
test1=>

the test.dmp file is
$ cat test.dmp
/system/workbin/등락종??.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.. 
but second case, creatdb with --encoding='utf8'

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

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

^^; postmaster log 
WARNING:  ignoring unconvertible UHC character 0xb85f
CONTEXT:  COPY t1, line 1: "/system/workbin/등락종??.TXT.20040319"
WARNING:  ignoring unconvertible UTF-8 character 0xeeb6f4
CONTEXT:  COPY t1, line 1: "/system/workbin/등락종??.TXT.20040319"
WARNING:  ignoring unconvertible UTF-8 character 0xeeb6f4
CONTEXT:  COPY t1, line 1: "/system/workbin/등락종??.TXT.20040319"
WARNING:  ignoring unconvertible UTF-8 character 0xeeb6f4
CONTEXT:  COPY t1, line 1: "/system/workbin/등락종??.TXT.20040319"
WARNING:  ignoring unconvertible UTF-8 character 0xeeb6f4
CONTEXT:  COPY t1, line 1: "/system/workbin/등락종??.TXT.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 progress
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!

Responses

pgsql-bugs by date

Next:From: Nick FarrellDate: 2004-10-27 02:33:50
Subject: Sequence creation bug: 8.0.0beta4 win32
Previous:From: Ed L.Date: 2004-10-27 01:32:03
Subject: Re: ia64 regression test failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group