BUG #1893: pg_dumpall - Search path order

Started by Daniel Naschenwengover 20 years ago2 messagesbugs
Jump to latest
#1Daniel Naschenweng
daniel.blumenau@gmail.com

The following bug has been logged online:

Bug reference: 1893
Logged by: Daniel Naschenweng
Email address: daniel.blumenau@gmail.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;

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Daniel Naschenweng (#1)
Re: BUG #1893: pg_dumpall - Search path order

"Daniel Naschenweng" <daniel.blumenau@gmail.com> writes:

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

This is not an error, it's only a notice.

regards, tom lane