HI Tom,
Sounds good. I would like to help with the self-contained case. What =
do you need from me?
Thank you,
Travis
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Sent: Monday, January 18, 2016 10:18 PM
To: Smith, Travis
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #13875: Error explaining query
travis.smith@iriworldwide.com writes:
> =3D# explain select count(1) from (SELECT DISTINCT=20
> "IRI_IT_M_2782_7472_O"."ATTR_VALUE",=20
> "IRI_IT_M_2782_7472_O"."SORT_ORDER",
> "IT_DIM_IRI_7472"."M_2796_KEY", "IT_DIM_IRI_7472"."M_2782_KEY" FROM=20
> "IT_DIM_IRI_7472", "IRI_IT_M_2782_7472_O" WHERE=20
> ("IT_DIM_IRI_7472"."S_848_KEY" =3D 4527492) AND=20
> ("IT_DIM_IRI_7472"."M_2782_KEY" =3D "IRI_IT_M_2782_7472_O"."AVP_KEY")=20
> ORDER BY "IT_DIM_IRI_7472"."M_2796_KEY" ASC,=20
> "IRI_IT_M_2782_7472_O"."SORT_ORDER" ASC,=20
> "IT_DIM_IRI_7472"."M_2782_KEY" ASC ) t;
> ERROR: variable not found in subplan target list
What I get is
ERROR: relation "IT_DIM_IRI_7472" does not exist LINE 4: "IT_DIM_IRI_7472"=
, "IRI_IT_M_2782_7472_O" WHERE
^
This does indeed sound like a bug, but without a self-contained test case, =
there's not a lot we can do about it.
regards, tom lane