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 - [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
