pgsql: adjust ACL owners for REASSIGN and ALTER OWNER TO
От | Alvaro Herrera |
---|---|
Тема | pgsql: adjust ACL owners for REASSIGN and ALTER OWNER TO |
Дата | |
Msg-id | E1aB8n5-00006W-Ry@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
adjust ACL owners for REASSIGN and ALTER OWNER TO When REASSIGN and ALTER OWNER TO are used, both the object owner and ACL list should be changed from the old owner to the new owner. This patch fixes types, foreign data wrappers, and foreign servers to change their ACL list properly; they already changed owners properly. Report by Alexey Bashtanov This is a backpatch of commit 59367fdf97c (for bug #9923) by Bruce Momjian to branches 9.1 - 9.4; it wasn't backpatched originally out of concerns that it would create a backwards compatibility problem, but per discussion related to bug #13666 that turns out to have been misguided. (Therefore, the entry in the 9.5 release notes should be removed.) Note that 9.1 didn't have privileges on types (which were introduced by commit 729205571e81), so this commit only changes foreign-data related objects in that branch. Discussion: http://www.postgresql.org/message-id/20151216224004.GL2618@alvherre.pgsql http://www.postgresql.org/message-id/10227.1450373793@sss.pgh.pa.us Branch ------ REL9_2_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/7af3dd540e29d057ff11d5c3ed946b071885c66f Modified Files -------------- src/backend/commands/foreigncmds.c | 56 ++++++++++++++- src/backend/commands/typecmds.c | 65 ++++++++++++++--- src/test/regress/expected/foreign_data.out | 104 ++++++++++++++-------------- 3 files changed, 161 insertions(+), 64 deletions(-)
В списке pgsql-committers по дате отправления: