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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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;
From | Date | Subject | |
---|---|---|---|
Next Message | Gerhard Kirchmann | 2005-09-19 13:37:42 | BUG #1894: postmaster does not start |
Previous Message | Daniel Naschenweng | 2005-09-19 12:15:40 | BUG #1892: pg_dumpall get five passwords |