Re: BUG #13875: Error explaining query
От | Tom Lane |
---|---|
Тема | Re: BUG #13875: Error explaining query |
Дата | |
Msg-id | 29170.1453177060@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | BUG #13875: Error explaining query (travis.smith@iriworldwide.com) |
Ответы |
Re: BUG #13875: Error explaining query
Re: BUG #13875: Error explaining query |
Список | pgsql-bugs |
travis.smith@iriworldwide.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
В списке pgsql-bugs по дате отправления: