Skip site navigation (1) Skip section navigation (2)

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

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To: PGBugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Error: could not find a feasible split point for "obs_v_file_id_index"
Date: 2004-08-30 13:02:02
Message-ID: 20040830070202.4e30b349@thunder.mshome.net (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Martin PittDate: 2004-08-30 13:05:00
Subject: Re: Fwd: Bug#260350: postgresql-dev: libpq3-config output is woeful
Previous:From: Peter EisentrautDate: 2004-08-30 12:39:24
Subject: Re: Fwd: Bug#260350: postgresql-dev: libpq3-config output is woeful

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group