Hey All,
While doing some daily processing, I ran across the following error:
ERROR: could not find a feasible split point for "obs_v_file_id_index"
STATEMENT: UPDATE obs_v SET mag = obs_v.imag + zp.zero_v + cg.color_v *
(obs_v.imag - i.imag), use = true FROM color_groups AS cg, zero_pair AS zp,
obs_i AS i, files AS f, groups AS g WHERE obs_v.star_id = i.star_id AND
obs_v.file_id = f.file_id AND cg.group_id = g.group_id AND g.night_id =
f.night_id AND g.group_id = 149 AND zp.pair_id = f.pair_id
version: 7.4.1.
table schema:
---------+---------+------------------------------------------------
x | real | not null
y | real | not null
imag | real | not null
smag | real | not null
loc | spoint | not null
obs_id | integer | not null default nextval('"obs_id_seq"'::text)
file_id | integer | not null
use | boolean | default false
solve | boolean | default false
star_id | integer |
mag | real |
Inexes: "obs_v_file_id_index" btree (file_id)
"obs_v_loc_index" gist (loc)
"obs_v_obs_id_index" btree (obs_id)
"obs_v_star_id_index" btree (star_id)
"obs_v_use_index" btree (use)
Foreign-key constraints:
"obs_v_files_constraint" FOREIGN KEY (file_id) REFERENCES files(file_id) ON
DELETE CASCADE
"obs_v_star_id_constraint" FOREIGN KEY (star_id) REFERENCES
catalog(star_id) ON DELETE SET NULL
Triggers:
obs_v_trig BEFORE INSERT OR DELETE OR UPDATE ON obs_v FOR EACH ROW EXECUTE
PROCEDURE observations_trigger
Help?
Cheers,
Rob
--
06:52:56 up 15 days, 17:15, 3 users, load average: 2.05, 2.12, 2.22
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004
