Re: planner fails on HEAD

a plan for modified query is

ohs=# explain analyze SELECT object_id,      inserted,      'ASSIGN_RSLT',      order_id,      2,      seqnum,
rejected_flat_file_id,     true 
FROM (  SELECT q.object_id,         fe.inserted,         q.order_id,         q.seqnum,         q.rejected_flat_file_id,
       q.rejected_result     FROM queue q          JOIN          outgoing.cps_forms f          ON f.id = q.object_id
ANDq.object_type = 'cp'          JOIN          flat_file_ex fe          ON fe.id = q.rejected_flat_file_id 
offset 0) x    WHERE rejected_result = 'ACTV';

QUERY PLAN

────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────Subquery
Scanon x  (cost=11.68..192.72 rows=1 width=24) (actual 
time=1.748..12.398 rows=139 loops=1)  Filter: (x.rejected_result = 'ACTV'::bpchar)  Rows Removed by Filter: 17  ->
Limit (cost=11.68..192.65 rows=6 width=29) (actual 
time=1.739..11.655 rows=156 loops=1)        ->  Nested Loop  (cost=11.68..192.65 rows=6 width=29) (actual
time=1.732..11.036 rows=156 loops=1)              ->  Hash Join  (cost=11.68..138.77 rows=15 width=21)
(actual time=1.459..6.987 rows=186 loops=1)                    Hash Cond: (q.object_id = f.id)                    ->
SeqScan on queue q  (cost=0.00..126.24 
rows=186 width=21) (actual time=0.032..4.658 rows=186 loops=1)                          Filter: (object_type =
'cp'::bpchar)                         Rows Removed by Filter: 4313                    ->  Hash  (cost=9.08..9.08
rows=208width=4) 
(actual time=1.402..1.402 rows=208 loops=1)                          Buckets: 1024  Batches: 1  Memory Usage: 5kB
                  ->  Seq Scan on cps_forms f 
(cost=0.00..9.08 rows=208 width=4) (actual time=0.008..0.576 rows=208
loops=1)              ->  Index Scan using flat_file_ex_pkey on flat_file_ex
fe  (cost=0.00..3.58 rows=1 width=12) (actual time=0.008..0.010 rows=1
loops=186)                    Index Cond: (id = q.rejected_flat_file_id)Total runtime: 12.846 ms
(16 rows)