"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> What do I use instead of the CatalogIndexInsert command to tell the index
> that a tuple has been removed?
Nothing. The tuple isn't really gone, and neither are its index
entries. Getting rid of them later is VACUUM's problem.
BTW, there already is code that cleans out pg_relcheck: see
RemoveRelCheck() in src/backend/catalog/heap.c.
regards, tom lane