Fabien COELHO wrote: > > Dear hackers, > > Some minor comments about the new tablespace feature in 8.0beta1: > > It seems to me that tablespaces and sequences are not yet prefectly > integrated. > > (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. > (3) psql auto completion does not have "CREATE/DROP TABLESPACE" in > its list. > > Maybe these non-important issues could be added to the TODO list. > I've noticed some todos about tablespaces, but not these. Yep, in patch queue. -- 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 6: Have you searched our list archives? http://archives.postgresql.org
