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


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to