Bug in pg_dumpall

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

Responses

Browse pgsql-general by date

  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