Error: could not find a feasible split point for "obs_v_file_id_index"

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