On 08/24/2015 03:46 AM, Simon Riggs wrote:
>
>
> ALTER TABLE foo ADD PARTITION NEXT;
>
> when a sequence of partitions has been defined
>
>
Or perhaps
ALTER TABLE foo ADD PARTITION NEXT nn;
So you can set up, say, a week's worth of daily partitions at once.
I could also imagine a variant that allows you to specify partitions up
to the one including some value.
cheers
andrew
