Bug in pg_dumpall - Mailing list 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