Re: BUG #2218: Variables selected in VIEWs under different names break queries using those views - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2218: Variables selected in VIEWs under different names break queries using those views
Date
Msg-id 21903.1138512359@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2218: Variables selected in VIEWs under different names break queries using those views  ("Nicholas" <hb@pg.x256.org>)
List pgsql-bugs
"Nicholas" <hb@x256.com> writes:
> SELECT cgm.id, g.name, mi.invitees FROM meeting_instances as mi JOIN
> meeting_versions as m ON m.iid = '33' JOIN groups as g ON g.id = m.team LEFT
> JOIN cachedgroupmembers as cgm ON cgm.groupid = m.team and not cgm.disabled
> and cgm.memberid = '55' WHERE mi.id = '33';
> ERROR:  variable not found in subplan target list

Could we see a *complete* example please?  I have no time or interest
to guess about the tables underlying this view.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Ricardo Solanilla"
Date:
Subject: BUG #2219: bug in 12000 rows update
Next
From: Brian Hirt
Date:
Subject: bug with aggregate + multi column index + index_scan