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])