From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: brandon.hsu@omniwaresoft.com.tw
Subject: REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects.
Date: Mon, 25 Mar 2019 03:00:28 +0000
Message-ID: <155348282848.9808.12629518043813943231@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-reassign-owned.html
Description:
Hi,
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.
But we find there is no any line describing the behavior in REASSIGN OWNED
page.
https://www.postgresql.org/docs/11/sql-reassign-owned.html
Later we find a note in the source code which mentions that DEFAULT
PRIVILEGE is not handled by REASSIGN OWNED.
https://doxygen.postgresql.org/pg__shdepend_8c_source.html#l01470
Is it possible to add a note in REASSIGN OWNED page for this behavior?
Thanks.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, brandon.hsu@omniwaresoft.com.tw
Subject: Re: REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects.
In-Reply-To: <155348282848.9808.12629518043813943231@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox