Re: 9.0RC1 error variable not found in subplan target lists - Mailing list 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