Christian Fowler wrote:
db=# \encoding UNICODE
the last four columns in the table are:
full_name_nd | character varying(200) | mod_date | timestamp without time zone | pc_char | character varying(4) | dim_char | character varying(16) |
[EMAIL PROTECTED] root]# env |grep LANG LANG=en_US.UTF-8
emm. guess you don't have PGCLIENTENCODING setting, what's the contend of full_name_nd? could it contain some multibyte character?
try:
export PGCLIENTENCODING=UNICODE
then reload the dump file, see if the error happens again? I guess there are some problematic character in full_name_nd field. you may use 'less' or 'more' command to check line 169371, see if it contain some weird chars.
regards
Laser
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
