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>
精彩评论