Skip site navigation (1) Skip section navigation (2)

dump + restore didn't include schemas

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 (view raw or flat)
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/


Responses

pgsql-hackers by date

Next:From: Tatsuo IshiiDate: 2004-01-31 02:25:22
Subject: Re: [PATCHES] v7.4.1 text_position() patch
Previous:From: Tom LaneDate: 2004-01-31 00:50:23
Subject: Re: Question about indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group