On PosgreSQl 8.0.0 beta 3 (on SuSE Linux 8.1) I tried this:
mkdir /opt/pgsql/data2 mkdir /opt/pgsql/data3 psql test1
test1=# CREATE TABLESPACE ts_test_1 OWNER testuser LOCATION '/opt/pgsql/data2'; CREATE TABLESPACE test1=# CREATE TABLESPACE ts_test_2 OWNER testuser LOCATION '/opt/pgsql/data3'; CREATE TABLESPACE test1=# \q
psql test1 testuser test1=> create table foobar ( foo varchar(50) ) TABLESPACE ts_test_1; CREATE TABLE test1=> select * from pg_tables where tablespace='ts_test_1'; schemaname | tablename | tablespace | tableowner | hasindexes | hasrules | hastriggers ------------+-----------+------------+------------+------------+----------+------------- public | foobar | ts_test_1 | testuser | f | f | f (1 row) test1=> create index ix_foobar on foobar(foo) TABLESPACE ts_test_2; CREATE INDEX test1=> select * from pg_indexes where tablename='foobar'; schemaname | tablename | tablespace | indexname | indexdef ------------+-----------+------------+-----------+------------------------------------------------------------------------- public | foobar | ts_test_1 | ix_foobar | CREATE INDEX ix_foobar ON foobar USING btree (foo) TABLESPACE ts_test_2 (1 row)
Why is index "ix_foobar" in tablespace "ts_test_1" and not in tablespace "ts_test_2" ? Is it a bug ?
regards Michael Kleiser
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org