> > Since partition is inheritance-based, a simple DROP or  "NO 
> > will do the job to deal with the partition. Do we want to reinvent 
> > additional syntax when these are around and are documented?
> Well, if the syntax for adding a new partition eventually 
> ends up as ALTER TABLE ADD PARTITION, then it would make more 
> sense that you remove a partition via ALTER TABLE DROP PARTITION.

But DROP PARTITION usually moves the data from this partition to other
so it is something different.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to