Postgres Pro
Downloads
Home   >   mailing lists

variable not found in subplan target list - Mailing list pgsql-general

From Roger Niederland
Subject variable not found in subplan target list
Date
Msg-id 4EAF452B.8080707@niederland.com
Whole thread Raw
List pgsql-general
Tree view
Hello,

I stripped down the original query to what is below.  I am not saying that the query below
is useful except to show an error I am getting in Postgresql 9.1.1 on both SL6.1 (64 bit) and
Windows 2008 server  9.1.1 (32-bit and 64-bit).  The error I am getting is:

ERROR: variable not found in subplan target list
SQL state: XX000

If I remove the inner join to person (at the end)  to works on 9.1.1

I tried this query on Postgresql 9.1.0 on Windows Vista (32-bit) and it works.
Also on the postgres 8.4 it works on both OS's.

Thanks,
Roger


SELECT
   COALESCE(FreshUps.employeeId, Appts.employeeId) AS employeeId
 FROM
 (
   SELECT
     COALESCE(Ups.employeeId, -1) AS employeeId
   FROM
   (
     SELECT Lead.salesmanId AS employeeId
     FROM Lead
     GROUP BY Lead.salesmanID) AS Ups
 ) AS FreshUps
 FULL OUTER JOIN
 (
   SELECT
     COALESCE(Ups.employeeId, -1) AS employeeId
   FROM
   (
     SELECT SalesAppointment.SalesmanID AS employeeID
     FROM SalesAppointment
     GROUP BY SalesAppointment.SalesmanID) AS Ups
 ) AS Appts USING (employeeId)
 
 INNER JOIN Employee USING (employeeid)
 INNER JOIN Person ON Employee.employeeId = Person.personId

pgsql-general by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: OOM Killer / PG9 / RHEL 6.1
Next
From: Graham Murray
Date:
Subject: postgresql-9.1.1 PQescapeByteaConn() generating incorrectly quoted output.