BUG #3672: ALTER 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.mamin@intershop.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