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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

"Marc Mamin" <m.mamin@intershop.de> writes:
> Description: ALTER <column> TYPE change the underlying index
> tablespace to default

Good catch, will fix.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly