Steve <cheetah@xxxxxxxxxx> writes: > Just dropping that index had no effect, but there's a LOT of indexes that > refer to receipt. So on a hunch I tried dropping all indexes that refer > to receipt date and that worked -- so it's the indexes that contain > receipt date that are teh problem. I'm still not having any luck reproducing the failure here. Grasping at straws again, I wonder if it's got something to do with the order in which the planner examines the indexes --- which is OID order. Could you send me the results of select indexrelid::regclass from pg_index where indrelid = 'detail_summary'::regclass order by indexrelid; regards, tom lane
