Fabien COELHO wrote:
>
> 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.
I can't remember why we didn't just make it orthoginal.
-- 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,
Pennsylvania19073