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

BUG #1893: pg_dumpall - Search path order

From: "Daniel Naschenweng" <daniel(dot)blumenau(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1893: pg_dumpall - Search path order
Date: 2005-09-19 12:23:40
Message-ID: 20050919122340.E2A94F0B4B@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1893
Logged by:          Daniel Naschenweng
Email address:      daniel(dot)blumenau(at)gmail(dot)com
PostgreSQL version: 8.1 beta2
Operating system:   Windows
Description:        pg_dumpall - Search path order
Details: 

When PostgreSQL make pg_dumpall, it set the search_path before a schema
create.
The import error:
NOTICE:  schema "usuario1" does not exist

--
-- PostgreSQL database cluster dump
--

\connect postgres

--
-- Roles
--

CREATE ROLE usuario1 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB
LOGIN;
ALTER ROLE usuario1 SET search_path TO usuario1, public, pg_catalog;
CREATE ROLE usuario2 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB
LOGIN;
ALTER ROLE usuario2 SET search_path TO usuario2, public, pg_catalog;
CREATE ROLE usuario3 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB
LOGIN;
ALTER ROLE usuario3 SET search_path TO usuario3, public, pg_catalog;

(...)

--
-- Name: usuario1; Type: SCHEMA; Schema: -; Owner: usuario1
--

CREATE SCHEMA usuario1;

Responses

pgsql-bugs by date

Next:From: Gerhard KirchmannDate: 2005-09-19 13:37:42
Subject: BUG #1894: postmaster does not start
Previous:From: Daniel NaschenwengDate: 2005-09-19 12:15:40
Subject: BUG #1892: pg_dumpall get five passwords

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