X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 610A532BE75 for ; Mon, 11 Oct 2004 16:40:06 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65697-03 for ; Mon, 11 Oct 2004 15:40:01 +0000 (GMT) Received: from mailgate3.cinetic.de (mailgate3.cinetic.de [217.72.192.164]) by svr1.postgresql.org (Postfix) with ESMTP id A395232BE0E for ; Mon, 11 Oct 2004 16:40:00 +0100 (BST) Received: from exchange02.int.cinetic.de (exchange02.int.cinetic.de [10.2.1.12]) by mailgate3.cinetic.de (8.11.6p2/8.11.2/SuSE Linux 8.11.0-0.4) with ESMTP id i9BFdxK05353 for ; Mon, 11 Oct 2004 17:39:59 +0200 Received: from [10.1.8.177] ([10.1.8.177]) by exchange02.int.cinetic.de with Microsoft SMTPSVC(6.0.3790.0); Mon, 11 Oct 2004 17:39:59 +0200 Message-ID: <416AA94F.30209@webde-ag.de> Date: Mon, 11 Oct 2004 17:39:59 +0200 From: Michael Kleiser Reply-To: mkl@webde-ag.de Organization: WEB.DE AG User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.7.2) Gecko/20040803 X-Accept-Language: de, , de-de, de-at, en, en-us MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Why is the index not created in the tablespace delivered in the create-index-command ?] Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 11 Oct 2004 15:39:59.0681 (UTC) FILETIME=[91175B10:01C4AFA8] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/158 X-Sequence-Number: 15151 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