tablespace and sequences?

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: tablespace and sequences?
Date: 2004-08-17 14:34:21
Message-ID: Pine.LNX.4.58.0408171615180.30419@sablons.cri.ensmp.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-hackers pgsql-hackers-win32


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?

(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(at)cri(dot)ensmp(dot)fr

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2004-08-17 14:55:06 Re: tablespace and sequences?
Previous Message Jose Oliveira 2004-08-16 20:26:05 edit command

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-17 14:48:45 Re: too short string for SQL in pg_stat_backend_activity
Previous Message Gaetano Mendola 2004-08-17 13:43:38 vacuums and ctid

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Tom Lane 2004-08-17 14:34:32 Re: [PATCHES] libpq build problem with <io.h> on MS VC++
Previous Message Mark Cave-Ayland 2004-08-17 14:33:49 Re: [PATCHES] GUC variables invisible to contrib/ modules