开发者

Cannot drop partitioned table in live system?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜