Re: psql 7.3.1: signal 11 + replace_vars_with_subplan_refs: variable not in subplan target list

Stefanos Harhalakis <v13@it.teithe.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;