开发者

Cannot drop partitioned table in live system?

开发者 https://www.devze.com 2023-01-17 23:01 出处:网络
I am not able to drop old partition tables in a postgresql 8.4.4 live db. My drop statement han开发者_如何学Pythongs with a access share lock on those partition tables. Is there any way I can drop tho

I am not able to drop old partition tables in a postgresql 8.4.4 live db. My drop statement han开发者_如何学Pythongs with a access share lock on those partition tables. Is there any way I can drop those tables?


Have you tried this first?

ALTER TABLE ONLY <child_table> NO INHERIT <parent_table>
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号