Denis Gasparin <[EMAIL PROTECTED]> writes:
> CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER;
> CREATE SCHEMA AUTHORIZATION aaa;
> All worked fine.
> The problem is in the pg_dumpall file.

> SET SESSION AUTHORIZATION aaa;
> CREATE SCHEMA aaa;

This is fixed in 7.4 --- I get

CREATE SCHEMA aaa AUTHORIZATION aaa;


                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to