Re: 9.0RC1 error variable not found in subplan target lists
От | Andrus |
---|---|
Тема | Re: 9.0RC1 error variable not found in subplan target lists |
Дата | |
Msg-id | C431C3DDFD584DA08C2F4185CFBFEFFE@andrusnotebook обсуждение исходный текст |
Ответ на | Re: 9.0RC1 error variable not found in subplan target lists (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: 9.0RC1 error variable not found in subplan target lists
|
Список | pgsql-general |
> Could we see a complete test case for this? No one can guess at the > tables, indexes, etc that might be needed to provoke the problem. Complete testcase is below. Should I try 9.0 release or other idea how to fix without removing primary key and keeping query structure so that query runs in all >=8.1 servers ? Andrus. create temp table klient (kood char(12) primary key, hinnak char(5)) on commit drop; SELECT * FROM (select 1) xtoode LEFT JOIN (SELECT hmguid.toode, COALESCE(hinnamtr.hinnak,klient.hinnak ) AS hinnak FROM ( SELECT hmhinnak.toode, ''::char as guid FROM ( select ''::char as toode, 1 as prioriteet ) prioriteet JOIN ( SELECT ''::char as toode, ''::text as guid, 1 as prioriteet ) hmhinnak USING (toode,prioriteet) ) hmguid JOIN (select ''::char as guid, ''::char as hinnak) hinnamtr USING (guid) LEFT JOIN klient ON klient.kood='' ) temphinnaks on true
В списке pgsql-general по дате отправления: