Updating system catalogs after a tuple deletion

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Updating system catalogs after a tuple deletion
Дата
Msg-id ECEHIKNFIMMECLEBJFIGAEINCAAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответы Re: Updating system catalogs after a tuple deletion  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi guys,

I have an experimental piece of code like this (that tries to remove
pg_relcheck entries):

deleted = 0;
while (HeapTupleIsValid(tup = heap_getnext(rcscan, 0))) {simple_heap_delete(rcrel, &tup->t_self);++deleted;
/* Keep catalog indices current */CatalogOpenIndices(Num_pg_relcheck_indices, Name_pg_relcheck_indices,
 relidescs);CatalogIndexInsert(relidescs, Num_pg_relcheck_indices, rcrel,
tup);CatalogCloseIndices(Num_pg_relcheck_indices,relidescs);
 
}

What do I use instead of the CatalogIndexInsert command to tell the index
that a tuple has been removed?  I don't see an equivalent CatalogIndexDelete
function...

Is there a better way of doing this?

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kovacs Zoltan
Дата:
Сообщение: Re: bug in PLPGSQL
Следующее
От: Franck Martin
Дата:
Сообщение: Re: Re: 7.2 items