Re: Bug in pg_dumpall - Mailing list pgsql-general

Denis Gasparin <denis@edistar.com> 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