Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > while (HeapTupleIsValid(lTuple = heap_getnext(sRel, 0)))
> > + {
> > heap_delete(lRel, &lTuple->t_self, NULL);
> > + if (RelationGetForm(lRel)->relhasindex)
> > + {
> > + Relationide
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > while (HeapTupleIsValid(lTuple = heap_getnext(sRel, 0)))
> > + {
> > heap_delete(lRel, &lTuple->t_self, NULL);
> > + if (RelationGetForm(lRel)->relhasindex)
> > + {
> > + Relationidescs[Num_pg_liste
Bruce Momjian <[EMAIL PROTECTED]> writes:
> while (HeapTupleIsValid(lTuple = heap_getnext(sRel, 0)))
> + {
> heap_delete(lRel, &lTuple->t_self, NULL);
> + if (RelationGetForm(lRel)->relhasindex)
> + {
> + Relationidescs[Num_pg_listener_indices];
OK, I have fixed the mistake I made that Tom pointed out. The fix will
be in 7.0.1. Tomorrow's snapshot will have it too.
Patch attached.
Thanks Tom.
> Jeff Davis <[EMAIL PROTECTED]> writes:
> > Regarding UNLISTEN: 'UNLISTEN ' does not remove
> > LISTEN entries for '' in 'pg_listener' class,
Jeff Davis <[EMAIL PROTECTED]> writes:
> Regarding UNLISTEN: 'UNLISTEN ' does not remove
> LISTEN entries for '' in 'pg_listener' class,
> nor does it prevent NOTIFYication.
It appears that this breakage is due to failure to maintain the index
on pg_listener that was added in 7.0. UNLISTEN is t
