BUG #1893: pg_dumpall - Search path order
От | Daniel Naschenweng |
---|---|
Тема | BUG #1893: pg_dumpall - Search path order |
Дата | |
Msg-id | 20050919122340.E2A94F0B4B@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #1893: pg_dumpall - Search path order
|
Список | pgsql-bugs |
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;
В списке pgsql-bugs по дате отправления: