From: Tom Lane <tgl@sss.pgh.pa.us>
To: brandon.hsu@omniwaresoft.com.tw
cc: pgsql-docs@lists.postgresql.org
Subject: Re: REASSIGN OWNED command page is not clear regarding to DEFAULT
 PRIVILEGE objects.
In-reply-to: <155348282848.9808.12629518043813943231@wrigleys.postgresql.org>
References: <155348282848.9808.12629518043813943231@wrigleys.postgresql.org>
Comments: In-reply-to PG Doc comments form <noreply@postgresql.org>
	message dated "Mon, 25 Mar 2019 03:00:28 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <23830.1553546466.1@sss.pgh.pa.us>
Date: Mon, 25 Mar 2019 16:41:06 -0400
Message-ID: <23831.1553546466@sss.pgh.pa.us>
Precedence: bulk

PG Doc comments form <noreply@postgresql.org> writes:
> Recently I try to drop a role without affecting objects dropped owned by it,
> and try to use REASSIGN OWNED command to transfer ownership.
> But we find DEFAULT PRIVILEGE policies are not transferred.
> ...
> Is it possible to add a note in REASSIGN OWNED page for this behavior?

The REASSIGN OWNED page does mention that it doesn't touch privileges
on non-owned objects, but I agree that it'd be better to be explicit
that that applies to default privileges.  Will fix, thanks for reporting!

			regards, tom lane