BUG #3672: ALTER <column> TYPE change the underlying index tablespace to default

The following bug has been logged online:

Bug reference: 3672
Logged by: Marc Mamin
Email address: m(dot)mamin(at)intershop(dot)de
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