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