"Christopher Kings-Lynne" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
- RE: [HACKERS] Updating system catalogs after a tuple deletio... Tom Lane
- RE: [HACKERS] Updating system catalogs after a tuple de... Stephan Szabo
- RE: [HACKERS] Updating system catalogs after a tupl... Philip Warner
- Re: [HACKERS] Updating system catalogs after a ... Tom Lane
- Re: [HACKERS] Updating system catalogs afte... Philip Warner
- Re: [HACKERS] Updating system catalogs afte... Stephan Szabo
- Re: [HACKERS] Updating system catalogs after a tupl... Tom Lane
- RE: [HACKERS] Updating system catalogs after a tuple de... Philip Warner
- RE: [HACKERS] Updating system catalogs after a tuple de... Stephan Szabo
- RE: [HACKERS] Updating system catalogs after a tuple de... Stephan Szabo