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: [EMAIL PROTECTED] --------------------------- Programmer & System Administrator - Edistar srl Via dell'artigianato, 1 31050 Vedelago TV Telefono: 0423-733209 Fax: 0423-733733 Internet: www.edistar.com
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match