Stefanos Harhalakis <v13(at)it(dot)teithe(dot)gr> writes:
> I'm stuck here with a query that kills postgresql backend.
Hoo, that was a fun one. Try this patch ...
regards, tom lane
*** src/backend/optimizer/plan/initsplan.c.orig Wed Sep 4 16:31:21 2002
--- src/backend/optimizer/plan/initsplan.c Thu Feb 6 18:39:07 2003
***************
*** 443,449 ****
else
{
/* this relid is for a true baserel */
! newrelids = lappendi(newrelids, lfirsti(relid));
}
}
relids = newrelids;
--- 443,450 ----
else
{
/* this relid is for a true baserel */
! if (!intMember(lfirsti(relid), newrelids))
! newrelids = lappendi(newrelids, lfirsti(relid));
}
}
relids = newrelids;