Re: REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects.

Hi, Tom,

Thanks a lot for improving the documentation to make it clearer.

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 於 2019年3月26日 週二 上午4:41寫道：

> PG Doc comments form <noreply(at)postgresql(dot)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
>

--

徐嘉群 / Brandon Hsu 0912423813

歐立威科技 Omniwaresoft Technology Inc.

Tel: (02)-2558-2656 #17 Fax:02-2558-5559

E-mail : brandon(dot)hsu(at)omniwaresoft(dot)com(dot)tw

部落格 : http://ravenonhill.blogspot.tw/

Address: 10349台北市大同區鄭州路 87 號 10 樓

--
----------------------------------------------------------------------------------------------------------------------------------------------------

本信件(包括任何附件)為機密信件。若您並非指定收信人，嚴禁複製、傳送、公開或使用其所載的全部或部份資料，任何對於本信件未經授權之使用或散播可能帶有法律責任。

若您偶然獲得此郵件，請回信或立即以電話通知寄件人並且從您的電腦系統中刪除本信件及所有附件，謝謝。
The
information in this
e-mail may be confidential; it is intended for use
solely by the
individual or entity named as the recipient hereof.
Disclosure, copying,
distribution, or use of the contents of this e-mail
by persons other than
the intended recipient may violate applicable
laws and if you have
received this e-mail in error, please delete the
original message and
notify us by collect call immediately. Thank you.

----------------------------------------------------------------------------------------------------------------------------------------------------