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