From: | Nicolaus Erichsen <nico(dot)erichsen(at)hsh-berlin(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | 'pg_dump --create' forgets database encoding |
Date: | 2002-10-17 14:45:07 |
Message-ID: | 200210171645.07547.nico.erichsen@hsh-berlin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello everybody,
pg_dump forgets to include the 'with encoding ....' statement in its ouput.
To reproduce:
----------------- snip ----------------------------
nico(at)nico:~> psql -Upostgres -dtemplate1
Welcome to psql, 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
template1=# create database enctest with encoding='latin1';
CREATE DATABASE
template1=# \q
nico(at)nico:~> pg_dump --create enctest
--
-- Selected TOC Entries:
--
\connect - postgres
--
-- TOC Entry ID 1 (OID 0)
--
-- Name: enctest Type: DATABASE Owner: postgres
--
Create Database "enctest";
\connect enctest postgres
nico(at)nico:~> pg_dump --version
pg_dump (PostgreSQL) 7.2
----------- snap ---------------
Thanks in advance for your efforts.
Btw: PostgreSQL is still one of the greatest programs I have ever seen. :-))
N.Erichsen
--
HSH Soft-und Hardware Vertriebs GmbH
Rudolf-Diesel-Straße 2 - 16321 Lindenberg
Tel. (030) 94004 - 509 Fax (030) 94004 - 400
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolaus Erichsen | 2002-10-17 15:06:36 | Issues with german 'Umlaute' |
Previous Message | Robert Treat | 2002-10-17 14:27:56 | Re: Fwd: [BUGS] Fwd: FATAL 1: Database dialup does not |