[pgsql-jp: 28791] Re: 空文字列を含むテーブルの\copy/pg_dump が失敗する

[sugita ＠ sra.co.jp]

From: Tatsuo Ishii <t-ishii ＠ sra.co.jp>
Subject: [pgsql-jp: 28790] Re: 空文字列を含むテーブルの\copy/pg_dump が失敗する
Date: Mon, 27 Jan 2003 10:12:15 +0900 (JST)

;;; > > もしかしてクライアント側のエンコーディングをUNICODE以外にしていますか？
;;; > 
;;; > PGCLIENTENCODING=EUC_JP
;;; > としてました。
;;; 
;;; うーん，同じように設定しましたが，こちらでは再現しませんねぇ．

  再現しました。

$ cat /etc/redhat-release 
Red Hat Linux release 7.3 (Valhalla)
$ uname -a
Linux srapc1943 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i686 unknown
$ psql uni
Welcome to psql 7.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

uni=# show server_encoding ;
 server_encoding 
-----------------
 UNICODE
(1 row)

uni=# set client_encoding to eucjp;
SET
uni=# show client_encoding ;
 client_encoding 
-----------------
 eucjp
(1 row)

uni=# \copy t1 to /tmp/aaa
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
\copy: connection pointer is NULL
!# 

$ psql
Welcome to psql 7.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

sugita=# \d t1
     Table "public.t1"
 Column | Type | Modifiers 
--------+------+-----------
 t      | text | 

sugita=# select * from t1;
 t 
---
(0 rows)

sugita=# 


Kenji Sugita