The following bug has been logged online: Bug reference: 3672 Logged by: Marc Mamin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Description: ALTER <column> TYPE change the underlying index tablespace to default Details:
steps to repeat: create table tbltest ( id serial, constraint tbltest_pk primary key (id) USING INDEX TABLESPACE tblspc_idx_ciclocal ) select tablespace from pg_indexes where indexname ='tbltest_pk' => tblspc_idx_ciclocal alter table tbltest ALTER id TYPE int2; select tablespace from pg_indexes where indexname ='tbltest_pk' => NULL "tbltest_pk" has been moved from its original tablespace to the default one. regards, Marc Mamin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
