BUG #9759: whe extend some varchar cols to varchar(n) , index filenode disappear, and 58P01 ERROR - Mailing list pgsql-bugs

From digoal@126.com
Subject BUG #9759: whe extend some varchar cols to varchar(n) , index filenode disappear, and 58P01 ERROR
Date
Msg-id 20140328115802.13982.97732@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      9759
Logged by:          digoal.zhou
Email address:      digoal@126.com
PostgreSQL version: 9.2.4
Operating system:   CentOS 5.x x64
Description:

whe I use SQL "alter table ... alter column ... type varchar;" extend some
varchar(n) columns to varchar, and then i select the table , it's raise
58P01 error, and i use  select relname from pg_class where
pg_relation_filepath(oid)='$the_filenode', the relname is index on the
table.
but this query plan is SeqScan, and one:
why index filenode is disappear?
two:
why i not use index scan also raise the index not open, in plan parse need
open the index file?
This error is not raise all tables.

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #9757: Why reclaim index deleted pages need twice vacuum
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #9749: ERROR: unexpected classid 3600