7.4 Beta1: variable not found in subplan target lists

Поиск
Список
Период
Сортировка
От Robert Creager
Тема 7.4 Beta1: variable not found in subplan target lists
Дата
Msg-id 20030806195702.799ae305.Robert_Creager@LogicalChaos.org
обсуждение исходный текст
Ответы Re: 7.4 Beta1: variable not found in subplan target lists  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: 7.4 Beta1: variable not found in subplan target lists  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hey again,

Received this error:

Aug  6 16:24:55 thunder postgres[7835]: [11-1] ERROR:  variable not
found in subplan target lists 

during this query:
  $dbh->do( qq/
DELETE FROM temp_obs_v
WHERE file_id IN  (SELECT file_id   FROM temp_obs_v NATURAL JOIN files   WHERE  group_id = $group_id      AND pair_id
=$pair_id) /);
 

on the 15th iteration (the previous 14 worked fine).

It is repeatable.  Something stupid again (other than the duplicate
indexes)?

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

tassiv=# \d temp_obs_i                    Table "public.temp_obs_i"Column  |  Type   |                   Modifiers
             
 
---------+---------+------------------------------------------------x       | real    | not nully       | real    | not
nullimag   | real    | not nullsmag    | real    | not nullloc     | spoint  | not nullobs_id  | integer | not null
defaultnextval('"obs_id_seq"'::text)file_id | integer | not nulluse     | boolean | default falsesolve   | boolean |
defaultfalsestar_id | integer | mag     | real    | 
 
Indexes:   "temp_obs_i_file_id_index" btree (file_id)   "temp_obs_i_index" gist (loc)   "temp_obs_i_loc_index" gist
(loc)  "temp_obs_i_obs_id_index" btree (obs_id)
 
Foreign-key constraints:   "temp_obs_i_files_constraint" FOREIGN KEY (file_id) REFERENCES
files(file_id) ON DELETE CASCADE Inherits: obs_root

tassiv=# \d files                                   Table "public.files" Column  |           Type           |
           Modifiers                    
 
----------+--------------------------+---------------------------------
---------------------- file_id  | integer                  | not null
default nextval('"files_file_id_seq"'::text) group_id | integer                |  pair_id  | integer                  |
date    | timestamp with time zone | not nullname     | character varying        | not nullra_min   | real
      | default 0ra_max   | real                     | default 0dec_min  | real                     | default 0dec_max
|real                     | default 0
 
Indexes:   "files_pkey" primary key, btree (file_id)   "files_name_key" unique, btree (name)   "files_id_index" btree
(file_id,group_id, pair_id)   "files_range_index" btree (ra_min, ra_max, dec_min, dec_max)
 
Foreign-key constraints:   "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE
CASCADE    "$2" FOREIGN KEY (pair_id) REFERENCES pairs(pair_id) ON
DELETE CASCADE



-- 19:43:52 up 5 days, 12:30,  3 users,  load average: 2.11, 2.07, 2.01

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: encoding question
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: encoding question