Hi, Tom, Thanks a lot for improving the documentation to make it clearer.
Tom Lane <t...@sss.pgh.pa.us> 於 2019年3月26日 週二 上午4:41寫道: > PG Doc comments form <nore...@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 > -- 徐嘉群 / Brandon Hsu 0912423813 歐立威科技 Omniwaresoft Technology Inc. Tel: (02)-2558-2656 #17 Fax:02-2558-5559 E-mail : brandon....@omniwaresoft.com.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. ----------------------------------------------------------------------------------------------------------------------------------------------------