BUG #4238: pg_class.relhasindex not updated by vacuum

From: "Lawrence Cohan" <lawrencec(at)1shoppingcart(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4238: pg_class.relhasindex not updated by vacuum
Date: 2008-06-13 14:34:04
Message-ID: 200806131434.m5DEY43b085076@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4238
Logged by: Lawrence Cohan
Email address: lawrencec(at)1shoppingcart(dot)com
PostgreSQL version: 8.2.5
Operating system: Linux 4.1.1
Description: pg_class.relhasindex not updated by vacuum
Details:

We rely on this column to build a list of tables restricted to only those
that have indexes to be rebuilt with CONCURRENTLY however the column is not
updated as documentation says by the vacuum. After a successful
analyze/vacuum/analyze against the entire database ALL tables from pg_class
have the pg_class.relhasindex = true even if they don't have any indexes.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-06-13 15:44:00 Re: BUG #4238: pg_class.relhasindex not updated by vacuum
Previous Message Miracapillo Alessandro 2008-06-13 11:04:32 R: Purge Oid