APR
Reputation: 7
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 hangs with a access share lock on those partition tables. Is there any way I can drop those tables?
Upvotes: 0
Views: 1364
Answers (1)
Matthew Wood
Reputation: 16417
Have you tried this first?
ALTER TABLE ONLY <child_table> NO INHERIT <parent_table>
Upvotes: 1
Related Questions
- Truncate partitioned table - PostgreSQL
- Partition key failing error for postgres table
- Postgres 10.3 heavily partitioned table and cannot delete any records
- Partition table created using 'CREATE TABLE AS'
- Postgres error on partitioned table (ERROR 42703 attribute 4 of type X has been dropped)
- Why cannot create partitioning table
- Why do partitioned tables in PostgreSQL take locks on other tables when being dropped?
- Can't drop a table in postgres
- Postgresql Partinioned Table Delete Trigger Fails
- Postgres partition pruning