Isn't a PK a CONSTRAINT and not an INDEX??? Some say "one or more fields" and others "one or more attributes" that uniquely identifies a record in a table and PG like many other databases would create a default internal index on that CONSTRAINT that can't be seen or dropped unless you will drop the Pkey. In that case the two separate pg_class relhasindex and relhaspkey would make sense indeed - just a thought nothing else and we'll take it as is.
Best regards, Lawrence Cohan. -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2008 12:33 PM To: Lawrence Cohan Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #4238: pg_class.relhasindex not updated by vacuum "Lawrence Cohan" <[EMAIL PROTECTED]> writes: > Is it possible that because of the PKEY's we have on the tables that > flag is still showing "true"? Uh, well certainly -- a PK is an index. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs