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: