Re: Updated ALTER TABLE ... SET TABLESPACE patch
От | Bruce Momjian |
---|---|
Тема | Re: Updated ALTER TABLE ... SET TABLESPACE patch |
Дата | |
Msg-id | 200407112352.i6BNqEn07514@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Updated ALTER TABLE ... SET TABLESPACE patch (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-patches |
OK, removed. --------------------------------------------------------------------------- Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Added to TODO; > > * Allow moving sequences and toast tables to other tablespaces > > in case no one does it. > > Please remove that; if I thought either one was a good idea, I would > have allowed it in the committed patch. > > Sequences are too small to be worth moving around, and may someday be > reimplemented in a fashion that doesn't use up a separate disk file for > each one. If we allow SET TABLESPACE on them we will be limiting our > future flexibility for no useful gain. > > Toast tables are bound to their parent tables because (a) pg_dump isn't > nearly smart enough to handle moving them, and (b) I've got concerns > about how you decide whether a person is authorized to move one. > > regards, tom lane > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-patches по дате отправления: