> > Since partition is inheritance-based, a simple DROP or "NO > INHERIT" > > 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 partitions, so it is something different. Andreas ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings