Re: Updating system catalogs after a tuple deletion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Updating system catalogs after a tuple deletion
Date: 2001-05-14 14:36:18
Message-ID: 9116.989850978@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-05-14 14:39:34 Re: Re: 7.2 items
Previous Message snpe 2001-05-14 14:35:47 Contraints in postgresql ?