Bug in pg_dumpall
От | Denis Gasparin |
---|---|
Тема | Bug in pg_dumpall |
Дата | |
Msg-id | 3FBE1B13.8040307@edistar.com обсуждение исходный текст |
Ответы |
Re: Bug in pg_dumpall
|
Список | pgsql-general |
I created a user with no superuser privileges: CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER; Then i created an authorization schema: CREATE SCHEMA AUTHORIZATION aaa; All worked fine. The problem is in the pg_dumpall file. Looking into the generated sql, i find that the schema is created with the command: CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER; SET SESSION AUTHORIZATION aaa; CREATE SCHEMA aaa; This fails giving me the following error: ERROR: aaaa: permission denied Any ideas? I'm using Postgresql 7.3.4. -- Ing. Denis Gasparin: denis@edistar.com --------------------------- Programmer & System Administrator - Edistar srl Via dell'artigianato, 1 31050 Vedelago TV Telefono: 0423-733209 Fax: 0423-733733 Internet: www.edistar.com
В списке pgsql-general по дате отправления: