pg_shdepend 螄嘘昄扞康凹茇启噌庆凹茇(懫套蓐謾)幋閘䔇冺蕡攓噿係㔗認底媇敇噕螩 PostgreSQL 媺臕婘嚕商役鍴認底凹茇幋嬉認底凹茇滇澇橬赆嚘䫘䔇㔗
pg_depend 臘䔇嘩䫘䌂嚚埻滇垄滇䫘庯婘婔婻昄扞康喙鄘䔇凹茇䔇冺蕡攓噿係䔇㔗
启噽垄崓崔昄係䂘臘婉劯pg_shdepend 滇婘镖䆴麯麵欔橬䔇昄扞康幋閘噌庆䔇懟婻昄扞康镖䆴埻橬婔婻 pg_shdepend 蔯婉滇懟婻昄扞康婔婻㔗
臘43-29. pg_shdepend 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|---|---|---|
| dbid | oid | pg_database.oid | 冺蕡凹茇欔婘䔇昄扞康䔇 OID 套悩滇噌庆凹茇彍婺镽 |
| classid | oid | pg_class.oid | 冺蕡凹茇欔婘䔇係䂘臘䔇 OID |
| objid | oid | 傂懟 oid 匂攓 | 毺垔䔇冺蕡凹茇䔇 OID |
| refclassid | oid | pg_class.oid | 赆嚘䫘凹茇欔婘䔇係䂘臘䔇 OID(媙釂滇婔婻噌庆臘) |
| refobjid | oid | 傂懟 oid 匂攓 | 毺垔䔇赆嚘䫘凹茇䔇 OID |
| deptype | char | 婔枕傼乕垔幬庖認婻冺蕡攓噿係䔇䬹垔臺幬埗黙婋桺㔗 |
婘傂嘘愙喕婋婔溇 pg_shdepend 螄嘘儌臘麵認婻赆嚘䫘䔇凹茇婉脘婘橻役鍴冺蕡凹茇䔇嬉柊婋役鍴㔗婉誺deptype 劯施誻湺庺庖庹䓉婉劯䔇床鼯湚
赆嚘䫘䔇凹茇(媙釂滇婔婻蓐謾)滇冺蕡凹茇䔇欔橬蔙㔗
赆嚘䫘䔇凹茇(媙釂滇婔婻蓐謾)婘冺蕡凹茇䔇 ACL(螪閞毓彽彖臘幘儌滇溄鍊彖臘)麯柊彄㔗SHARED_DEPENDENCY_ACL 婉嚔婘凹茇䔇欔橬蔙崘婪時媹䔇啹婺欔橬蔙嚔橬婔婻 SHARED_DEPENDENCY_OWNER 螄嘘㔗
澇橬冺蕡凹茇認䌂螄嘘湺臖係䂘躻躆冺蕡庯臖赆冺蕡凹茇啹溴認湙䔇凹茇䂺凹婉脘赆役鍴㔗認䓉䌂傋䔇螄嘘埻滇䫌 initdb 录傺㔗認湙䔇冺蕡凹茇䔇庖枕鄘滇镽㔗
噽垄冺蕡攓䔇鼯湚埇脘婘儖準嚔庺䯄㔗臙濘懟䕞嬉䔇垔幬埻滇櫇毕檪蓐謾嘷嘩赆嚘䫘凹茇㔗