On 2005-06-13, "Marc G. Fournier" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq