Skip to content

Check for concurrently when running alter table t detach partition p #831

@sbdchd

Description

@sbdchd

Detaching a partition requires requires an access exclusive lock that can be avoided by passing in concurrently.

https://www.postgresql.org/docs/current/ddl-partitioning.html

https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-DETACH-PARTITION

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions