Re: Updated ALTER TABLE ... SET TABLESPACE patch

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> 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.

> Why do we allow them to be created in tablespaces in the first place
> then?  Seems like a bit of a misfeature?  I mean we don't allow views in
> tablespaces...

I had forgotten that the original patch allowed that.  Personally I'd
vote for taking it out, for the above-stated reasons --- any objections?

If people do want to have it then we can instead change ALTER SET
TABLESPACE to allow sequences; but we'd also need a nontrivial addition
to pg_dump, so there had better be a better reason than "might be nice
to have".

            regards, tom lane