Detaching multiple partitions in 1 ALTER TABLE statement

From: Ben Hood <ben(at)relops(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Detaching multiple partitions in 1 ALTER TABLE statement
Date: 2019-06-20 14:19:48
Message-ID: F0E75DFF-D633-447A-B4BA-84253B1D4AB0@relops.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-06-20 14:26:44 Re: Row data is reflected in DETAIL message when constraints fail on insert/update
Previous Message Adrian Klaver 2019-06-20 14:12:44 Re: Row data is reflected in DETAIL message when constraints fail on insert/update