Robert Creager <Robert_Creager(at)LogicalChaos(dot)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