Re: BUG #9606: pg_class relhaspkey column not updated on removal of primary key

Jeff Frost <jeff@pgexperts.com> writes:
> Interestingly, on 9.1.11, I have a table where the pkey was added after the fact, then dropped, but it still shows as
relhaspkeyeven though I manually vacuumed it: 

IIRC, VACUUM only clears relhaspkey if there are *no* indexes left --- it
doesn't bother to check whether there's one calling itself indisprimary.
We could possibly change that but it's not clear that it's worth any
effort, given that the column would still have to be defined the same
way.

            regards, tom lane