> 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?
No. I was about to, though. Backing it out now.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
