BUG #6135: I wander in the backup of the bank, Portuguese generation of characters, atmosphere windows xp, post - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      6135
Logged by:          andre luiz
Email address:      andreluiz1111@gmail.com
PostgreSQL version: 9.0.4
Operating system:   windows xp
Description:        I wander in the backup of the bank, Portuguese
generation of characters, atmosphere windows xp, post
Details:

I wander in the backup of the bank, Portuguese generation of characters,
atmosphere windows xp, postgresql enconding utf-8.
It is not generating the characters correctly in Portuguese (accentuation,
cedilla - example:  õ, ç)
1. Generation of the table:
CREATE TABLE area (
    id_area  serial NOT NULL,
    codigo smallint NOT NULL,
    nome character varying(40)
);
ALTER TABLE ONLY area
    ADD CONSTRAINT pk_area PRIMARY KEY (id_area);
INSERT INTO area (id_area, codigo, nome) VALUES (1, 1, 'Almoço');
INSERT INTO area (id_area, codigo, nome) VALUES (2, 2, 'Refeição');
INSERT INTO area (id_area, codigo, nome) VALUES (3, 3, 'Cardápio');

2:  The Backup of the bank presents mistakes in the command insert - loss of
the characters in Portuguese:
--
-- PostgreSQL database dump
--

-- Dumped from database version 9.0.4
-- Dumped by pg_dump version 9.0.4
-- Started on 2011-07-30 22:55:45

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 1785 (class 1262 OID 16432)
-- Name: teste01; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE teste01 WITH TEMPLATE = template0 ENCODING = 'UTF8'
LC_COLLATE = 'Portuguese, Brazil' LC_CTYPE = 'Portuguese, Brazil';


ALTER DATABASE teste01 OWNER TO postgres;

\connect teste01

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 308 (class 2612 OID 11574)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--

CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1501 (class 1259 OID 16435)
-- Dependencies: 5
-- Name: area; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE area (
    id_area integer NOT NULL,
    codigo smallint NOT NULL,
    nome character varying(40)
);


ALTER TABLE public.area OWNER TO postgres;

--
-- TOC entry 1500 (class 1259 OID 16433)
-- Dependencies: 1501 5
-- Name: area_id_area_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE area_id_area_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.area_id_area_seq OWNER TO postgres;

--
-- TOC entry 1788 (class 0 OID 0)
-- Dependencies: 1500
-- Name: area_id_area_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner:
postgres
--

ALTER SEQUENCE area_id_area_seq OWNED BY area.id_area;


--
-- TOC entry 1789 (class 0 OID 0)
-- Dependencies: 1500
-- Name: area_id_area_seq; Type: SEQUENCE SET; Schema: public; Owner:
postgres
--

SELECT pg_catalog.setval('area_id_area_seq', 1, false);


--
-- TOC entry 1779 (class 2604 OID 16438)
-- Dependencies: 1500 1501 1501
-- Name: id_area; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE area ALTER COLUMN id_area SET DEFAULT
nextval('area_id_area_seq'::regclass);


--
-- TOC entry 1782 (class 0 OID 16435)
-- Dependencies: 1501
-- Data for Name: area; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO area VALUES (1, 1, 'Almoço');
INSERT INTO area VALUES (2, 2, 'Refeição');
INSERT INTO area VALUES (3, 3, 'Cardápio');


--
-- TOC entry 1781 (class 2606 OID 16440)
-- Dependencies: 1501 1501
-- Name: pk_area; Type: CONSTRAINT; Schema: public; Owner: postgres;
Tablespace:
--

ALTER TABLE ONLY area
    ADD CONSTRAINT pk_area PRIMARY KEY (id_area);


--
-- TOC entry 1787 (class 0 OID 0)
-- Dependencies: 5
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2011-07-30 22:55:45

--
-- PostgreSQL database dump complete
--