From: | "Dan Langille" <dan(at)langille(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | dump + restore didn't include schemas |
Date: | 2004-01-31 02:10:55 |
Message-ID: | 401AC85F.29157.17799FCB@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi folks,
I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the
schemas which existed in the original databases were not created in
the new database.
The CREATE SCHEMA commands are there...
\connect "freebsddiary.org"
--
-- PostgreSQL database dump
--
SET SESSION AUTHORIZATION 'www';
--
-- TOC entry 2 (OID 3642999)
-- Name: www; Type: SCHEMA; Schema: -; Owner: www
--
CREATE SCHEMA www;
But not in the resulting database:
freebsddiary.org=# set search_path = www, phorum, public, pg_catalog;
ERROR: schema "www" does not exist
freebsddiary.org=# set search_path = phorum, public, pg_catalog;
ERROR: schema "phorum" does not exist
freebsddiary.org=#
New issue? Known bug?
--
Dan Langille : http://www.langille.org/
BSDCan - http://www.bsdcan.org/
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2004-01-31 02:25:22 | Re: [PATCHES] v7.4.1 text_position() patch |
Previous Message | Tom Lane | 2004-01-31 00:50:23 | Re: Question about indexes |