From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 9.0RC1 error variable not found in subplan target lists |
Date: | 2010-09-25 21:01:05 |
Message-ID: | C431C3DDFD584DA08C2F4185CFBFEFFE@andrusnotebook |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-25 21:21:55 | Re: 9.0RC1 error variable not found in subplan target lists |
Previous Message | Thom Brown | 2010-09-25 20:38:02 | Re: Streaming Replication |