I'm not sure if you're saying I should ignore these errors... I'm using dumps from DB airaburst. >postgres=# \l List of databases Name | Owner | Encoding ------------+----------+----------- airburst | root | SQL_ASCII lt_dev1 | postgres | UTF8 lt_dev2 | postgres | UTF8 lt_reports | postgres | UTF8 postgres | postgres | UTF8 template0 | postgres | UTF8 template1 | postgres | UTF8 (7 rows) ============================================ Looking at the dump of one table there... -- -- PostgreSQL database dump -- -- Started on 2008-02-25 12:28:48 PST SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 1455 (class 1259 OID 20378) -- Dependencies: 1839 2 -- Name: board_posts; Type: TABLE; Schema: public; Owner: airburst; Tablespace: ============================================ The error I get on trying to import it. postgres@flexo:~/WORKING_DATA/airburst_tables$ psql lt_dev1 -f ./table_board_posts.sql SET SET SET SET SET SET SET SET CREATE TABLE ALTER TABLE psql:./table_board_posts.sql:248: ERROR: invalid byte sequence for encoding "UTF8": 0x91 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". CONTEXT: COPY board_posts, line 8 CREATE INDEX Thank you! |
