Re: Bug in pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Denis Gasparin <denis(at)edistar(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bug in pg_dumpall
Date: 2003-11-21 16:21:46
Message-ID: 12765.1069431706@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Denis Gasparin <denis(at)edistar(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-11-21 16:31:07 Re: Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB / MySQL appliance for Linux arrives
Previous Message Keith C. Perry 2003-11-21 16:20:03 Re: PGSQL on shared hosting