Re: Updated ALTER TABLE ... SET TABLESPACE patch

OK, removed.

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073