Postgres Pro
Downloads
Home   >   mailing lists

Re: Updating system catalogs after a tuple deletion - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Updating system catalogs after a tuple deletion
Date
Msg-id 9116.989850978@sss.pgh.pa.us
Whole thread Raw
In response to Updating system catalogs after a tuple deletion  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses RE: Updating system catalogs after a tuple deletion  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Coping with huge deferred-trigger lists
Next
From: Tom Lane
Date:
Subject: Re: bug in PLPGSQL