| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | brandon(dot)hsu(at)omniwaresoft(dot)com(dot)tw |
| Subject: | REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects. |
| Date: | 2019-03-25 03:00:28 |
| Message-ID: | 155348282848.9808.12629518043813943231@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-03-25 20:41:06 | Re: REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects. |
| Previous Message | Jeff Janes | 2019-03-20 18:50:21 | asynchronous commit risk window is overly optimistic |