Bruce Momjian <[EMAIL PROTECTED]> writes:
> while (HeapTupleIsValid(lTuple = heap_getnext(sRel, 0)))
> + {
> heap_delete(lRel, &lTuple->t_self, NULL);
> + if (RelationGetForm(lRel)->relhasindex)
> + {
> + Relation idescs[Num_pg_listener_indices];
> + CatalogOpenIndices(Num_pg_listener_indices, Name_pg_listener_indices,
>idescs);
> + CatalogIndexInsert(idescs, Num_pg_listener_indices, lRel, rTuple);
> + CatalogCloseIndices(Num_pg_listener_indices, idescs);
> + }
> + }
What?? heap_delete doesn't require index updates AFAIK. Have you
tested this?
regards, tom lane