Christopher Kings-Lynne <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to