On 6/20/19 9:00 AM, Simon Riggs wrote:
On Thu, 20 Jun 2019 at 15:19, Ben Hood <mailto:b...@relops.com>> wrote:
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
On Thu, 20 Jun 2019 at 15:19, Ben Hood wrote:
> 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
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 ",&qu
