Re: tablespace and sequences?

Dear Bruce,

> > (1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
> > to be implemented.
> >
> > (2) when creating an implicit sequence with SERIAL, the sequence
> > is created in the tablespace of the schema/database, not the one
> > of the table, although indexes are added to the tablespace
> > of the table. It would seem more logical to put it in
> > the same table space as the table by default?
>
> We decided it didn't make much sense to allow the on-row sequences to be
> anywhere but the default tablespace.

Hmmm...

I can understand the performance/utility rationale, but I don't like the
lack of orthogonality on principle. I like elegance;-) As a sequence looks
a lot like a table, I guess it should not be that hard to have it anyway.

Well, just my little opinion, and not a big issue.

Thanks for your answer.

--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr