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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match