On Thu, Oct 29, 2009 at 7:14 PM, Robert Haas <robertmh...@gmail.com> wrote: >> CREATE TABLE does not require PARTITION to be a reserved keyword, >> but there are conflicts in ALTER TABLE ADD/DROP PARTITION: >> >> * ALTER TABLE ... DROP [COLUMN] name [CASCADE | RESTRICT] >> * ALTER TABLE ... DROP PARTITION name [CASCADE | RESTRICT] >> >> There are some solutions:
Do we need a DROP PARTITION command at all? What would it even do? Drop the partition from the parent table and throw it away in one step? I think in actual practice people usually remove the partition from the parent table first, then do things like archive it before actually throwing it away. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers