Hi,
I have file with this code: ---------- \l SHOW SERVER_ENCODING; SHOW CLIENT_ENCODING; --- Languages table --- CREATE TABLE lang ( --- 'id' is here lang abbreviation --- id varchar(3) PRIMARY KEY, name varchar(16) NOT NULL --- lang fullname ); COPY lang FROM stdin; EN English DE German JP Japanese \. ---------- and now I use latest PostgreSQL from CVS: $ psql anydb < langs.sql List of databases Name | Owner | Encoding -----------+----------+----------- anydb | zakkr | UNICODE template0 | postgres | SQL_ASCII template1 | postgres | SQL_ASCII test | postgres | SQL_ASCII (4 rows) server_encoding ----------------- UNICODE (1 row) client_encoding ----------------- LATIN1 (1 row) NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'lang_pkey' for table 'lang' CREATE TABLE server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. lost synchronization with server, resetting connection connection to server was lost In the server log file is: TRAP: FailedAssertion("!(len > 0)", File: "utf8_and_iso8859_1.c", Line: 45) If I use INSERT instead COPY it's OK. Karel -- Karel Zak <[EMAIL PROTECTED]> http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org