Josh Berkus wrote: > #3: ALTER TABLE .... CHANGE TABLESPACE: > This is strictly in the class of "would be a very nice & useful feature if > it's not too difficult". ? > > Given how painful it is to drop & replace a table with multiple dependencies > (on some databases, only possible by droping & re-loading the entire > database) it would be nice to have an ALTER TABLE command that moved the > table to another tablespace. ? ?It doesn't *seem* to me that this would be a > very challenging bit of programming, as the operation would be very similar > to REINDEX in the manipulation of files. ? (But what I know, really?) > > Once tablespaces are a feature and some users start using them for quota > management, there will quickly develop situations where the original > tablespace for a db runs out of room and can't be resized. ? Being able to > move the table "in situ" then becomes vital, especially on very large > databases ... and when someday combined with partitioned tables, will become > essential. > > Further, we will get an *immediate* flurry of requests from users who just > upgraded to 7.5 and want to make use of the tablespaces feature on an > existing production database.
If we don't implement moving tables between tablespaces, we should add a stub for it in the grammer and mention it is not implemented yet, because if we don't, we will get tons of questions. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
