On Tue, Apr 21, 2009 at 11:13 AM, <vac...@quantentunnel.de> wrote: > oh sorry .. > > but what I miss in this discussion - where we can define tablespace? > > CREATE PARTITIONS ON <table> ( > > CASE WHEN <condition> THEN emp_xxx [IN <tablespace>], > CASE WHEN <condition> THEN emp_yyy [IN <tablespace>], > CASE WHEN <condition> emp_zzz [IN <tablespace>], > ELSE emp_default [IN <tablespace>] > )
Oh blech. That IN <tablespace> syntax is awful. What about the other relevant parameters to CREATE TABLE - where are you going to put those? WITH (<storage parameter>) WITH OIDS WITHOUT OIDS And what happens when I need to alter a partition after the fact, say to move it to a new tablespace, or change the fillfactor? Since your syntax doesn't give names to the partitions, how will I refer to them later? ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
