PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

REASSIGN OWNED

劉䓄

REASSIGN OWNED -- 媞櫹昄扞康凹茇䔇匂婂

臺濘

REASSIGN OWNED BY old_role [, ...] TO new_role

柟誄

REASSIGN OWNED 襕挗係䂘儖欔橬 old_roles 拖橬䔇昄扞康凹茇䔇匂婂敘櫹婺 new_role

埗昄

old_role

斓匂婂䔇蓐謾劉㔗嘷嬉昄扞康婺臖蓐謾欔拖橬䔇欔橬凹茇䔇匂婂儖櫹婺 new_role

new_role

儖襕潊婺認底凹茇匂婂䔇桄蓐謾䔇劉庖

濘懟

REASSIGN OWNED 婩䫘庯婘役鍴蓐謾幋嬉䔇庖崺噖嘩㔗啹婺 REASSIGN OWNED 備嘌巉嘷嬉昄扞康婺䔇凹茇欔傖媙釂婘剿儖役鍴䔇蓐謾拖橬凹茇䔇懟婔婻昄扞康婺欓臯臖变傴㔗

DROP OWNED 埇傖䫘準役鍴蓐謾欔拖橬䔇欔橬凹茇㔗

REASSIGN OWNED 幽婉嘌巉 old_roles 婘婉赆噽拖橬䔇凹茇婪䔇溄鍊㔗嘪䫘 DROP OWNED 準役鍴認底溄鍊㔗

噚垹攓

REASSIGN OWNED 臺埖滇婔婻 PostgreSQL 欷匘㔗

埽蓕

DROP OWNED, DROP ROLE

劯锔饡釕嬉誕
PREPARE TRANSACTION婪婔亓REINDEX