Hi, I’m wondering what is the syntax for detaching multiple partitions in 1 ALTER TABLE statement.
I’ve tried this: # ALTER TABLE movement_legs DETACH PARTITION movement_legs_2019_06_20_11_15, DETACH PARTITION movement_legs_2019_06_20_11_20; psql: ERROR: syntax error at or near "," LINE 1: ...gs DETACH PARTITION movement_legs_2019_06_20_11_15, DETACH P… The documentation suggests "DETACH PARTITION can be combined into a list of multiple alterations to be applied together”: https://www.postgresql.org/docs/12/sql-altertable.html But I haven’t found an example of where multiple partitions are detached in 1 statement. This is using version 12 beta 1. Many thanks, Ben
