Re: REINDEX SYSTEM tables ... index disappearing ... ?

On 2005-06-13, "Marc G. Fournier" <scrappy@postgresql.org> wrote:
>
> 'k, I've been playing around with the REINDEX stuff, and either I'm 
> mis-understanding something, or there is a bug in 7.4.x ...
>
> If I do a:
>
> REINDEX TABLE pg_statistic;
>
> my 'on disk' INDEX is disappearing, altho there is no errors being 
> generated:
>
> # select oid,relname from pg_class where relname like 'pg_statistic%';
>    oid  |           relname
> -------+------------------------------
>   16408 | pg_statistic
>   16647 | pg_statistic_relid_att_index
> (2 rows)
>
> But, on disk:
>
> $ ls -l 16408 16647
> ls: 16647: No such file or directory

The relfilenode of the index relation changes, so it's no longer equal to
the OID. If you look on-disk for the relfilenode, you will find it.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services