Re: 7.4 Beta1: variable not found in subplan target lists - Mailing list pgsql-hackers

Robert Creager <Robert_Creager@LogicalChaos.org> writes:
> tassiv=# explain DELETE FROM temp_obs_i  
> tassiv-# WHERE file_id IN 
> tassiv-#    (SELECT file_id 
> tassiv(#     FROM temp_obs_i NATURAL JOIN files
> tassiv(#     WHERE  group_id = 3 
> tassiv(#        AND pair_id  = 25) 
> tassiv-# ;
> ERROR:  variable not found in subplan target lists

Mph, looks like I broke something with the IN-optimization work.
Thanks for the test case --- will look into it.
        regards, tom lane