From: | "Smith, Travis" <Travis(dot)Smith(at)IRIWorldwide(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #13875: Error explaining query |
Date: | 2016-01-19 14:22:52 |
Message-ID: | BY2PR0101MB0840287BED606A6E6CE07028F4C10@BY2PR0101MB0840.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, January 18, 2016 10:18 PM
To: Smith, Travis
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #13875: Error explaining query
travis(dot)smith(at)iriworldwide(dot)com writes:
> =# explain select count(1) from (SELECT DISTINCT
> "IRI_IT_M_2782_7472_O"."ATTR_VALUE",
> "IRI_IT_M_2782_7472_O"."SORT_ORDER",
> "IT_DIM_IRI_7472"."M_2796_KEY", "IT_DIM_IRI_7472"."M_2782_KEY" FROM
> "IT_DIM_IRI_7472", "IRI_IT_M_2782_7472_O" WHERE
> ("IT_DIM_IRI_7472"."S_848_KEY" = 4527492) AND
> ("IT_DIM_IRI_7472"."M_2782_KEY" = "IRI_IT_M_2782_7472_O"."AVP_KEY")
> ORDER BY "IT_DIM_IRI_7472"."M_2796_KEY" ASC,
> "IRI_IT_M_2782_7472_O"."SORT_ORDER" ASC,
> "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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-01-19 14:34:31 | Re: BUG #13875: Error explaining query |
Previous Message | Aaron W. Swenson | 2016-01-19 14:10:52 | Re: BUG #13873: Pg_upgrade problem from 9.4 to 9.5 |