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

On 2005-06-13, "Marc G. Fournier" <scrappy(at)postgresql(dot)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