Skip site navigation (1) Skip section navigation (2)

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

From: "Marc Mamin" <m(dot)mamin(at)intershop(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3672: ALTER <column> TYPE change the underlying index tablespace to default
Date: 2007-10-12 12:50:55
Message-ID: 200710121250.l9CCotm6094304@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Timur LuchkinDate: 2007-10-12 13:01:07
Subject: BUG #3673: Untrusted perl language: ERROR: could not open relation 1663/16384/1259: No such file or directory
Previous:From: Magnus HaganderDate: 2007-10-12 10:24:05
Subject: Re: Win XP(SP2) install error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group