From: | Denis Gasparin <denis(at)edistar(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Bug in pg_dumpall |
Date: | 2003-11-21 14:02:59 |
Message-ID: | 3FBE1B13.8040307@edistar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)edistar(dot)com
---------------------------
Programmer & System Administrator - Edistar srl
Via dell'artigianato, 1
31050 Vedelago TV
Telefono: 0423-733209
Fax: 0423-733733
Internet: www.edistar.com
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Seibold | 2003-11-21 14:04:22 | Open source data modeling tools for PostgreSQL |
Previous Message | Markus Seibold | 2003-11-21 13:48:22 | Open source data modeling tools for PostgreSQL |