dbTalk Databases Forums  

[BUGS] BUG #1893: pg_dumpall - Search path order

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1893: pg_dumpall - Search path order in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daniel Naschenweng
 
Posts: n/a

Default [BUGS] BUG #1893: pg_dumpall - Search path order - 09-19-2005 , 10:06 AM







The following bug has been logged online:

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] BUG #1893: pg_dumpall - Search path order - 09-19-2005 , 10:32 AM






"Daniel Naschenweng" <daniel.blumenau (AT) gmail (DOT) com> writes:
Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.