tablespace and sequences? - Mailing list pgsql-hackers

From Fabien COELHO
Subject tablespace and sequences?
Date
Msg-id Pine.LNX.4.58.0408171615180.30419@sablons.cri.ensmp.fr
Whole thread Raw
Responses Re: tablespace and sequences?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: tablespace and sequences?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: tablespace and sequences?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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,
notthe one   of the table, although indexes are added to the tablespace   of the table. It would seem more logical to
putit in   the same table space as the table by default?
 

(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.

Have a nice day,

-- 
Fabien Coelho - coelho@cri.ensmp.fr


pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: vacuums and ctid
Next
From: Tom Lane
Date:
Subject: Re: too short string for SQL in pg_stat_backend_activity