Stefanos Harhalakis <[EMAIL PROTECTED]> 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;
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
