On Mar 9, 2007, at 3:31 AM, Zeugswetter Andreas ADI SD wrote:
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.
It does? IIRC every partitioning system I've seen DROP PARTITION
drops the data as well. It's up to you to move it somewhere else if
you want to keep it.
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
