Re: Server process exited with status 139 (meaning?)

Ed Loehr wrote:
> > > I don't need help on this as I found workable queries for my purposes,
> > > but here is a simplified core-dumper (7.0beta3) for posterity...
> >

test=# -- Here's the offending query...
test=# SELECT f.d, r.start_time::date, r.duration AS "r_dur",
test-#        z.duration AS "z_dur", f.d,
test-#        (r.start_time - '1 day'::interval)::date AS "leave",
test-#        (r.start_time + (z.duration||' days')::interval)::date AS
"return"
test-# FROM foo f, bar r, baz z
test-# WHERE r.id = 2
test-#   AND z.bar_id = 2
test-#   AND (f.d = (r.start_time - '1 day'::interval)::date 
test(#     OR f.d = (r.start_time + (z.duration||' days')::interval));    d      |  ?column?  | r_dur | z_dur |     d
  |   leave    |  
 
return   
------------+------------+-------+-------+------------+------------+------------1995-06-17 | 1995-06-18 |     3 |     3
|1995-06-17 | 1995-06-17 |
 
1995-06-21
(1 row)

test=# 
test=# explain SELECT f.d, r.start_time::date, r.duration AS "r_dur",
test-#        z.duration AS "z_dur", f.d,
test-#        (r.start_time - '1 day'::interval)::date AS "leave",
test-#        (r.start_time + (z.duration||' days')::interval)::date AS
"return"
test-# FROM foo f, bar r, baz z
test-# WHERE r.id = 2
test-#   AND z.bar_id = 2
test-#   AND (f.d = (r.start_time - '1 day'::interval)::date 
test(#     OR f.d = (r.start_time + (z.duration||' days')::interval));
NOTICE:  QUERY PLAN:

Nested Loop  (cost=0.00..5354.86 rows=1990 width=28) ->  Nested Loop  (cost=0.00..104.86 rows=100 width=24)       ->
SeqScan on baz z  (cost=0.00..22.50 rows=10 width=8)       ->  Index Scan using bar_id_key on bar r  (cost=0.00..8.14
 
rows=10 width=16) ->  Seq Scan on foo f  (cost=0.00..20.00 rows=1000 width=4)

EXPLAIN
test=# select version();                           version                            
---------------------------------------------------------------PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc
2.95.2
(1 row)


Works fine on my Debian 'woody' system on my laptop.


Also, looking at your other query:

test=#         
test=# -- Here's the offending query...
test=# SELECT f.d, r.start_time::date, r.duration AS "r_dur", z.duration
AS
test-# "z_dur"
test-# FROM foo f, bar r, baz z
test-# WHERE r.id = 2 
test-#   AND z.bar_id = 2
test-#   AND f.d = (r.start_time - '1 day'::interval)::date ;d | ?column? | r_dur | z_dur 
---+----------+-------+-------
(0 rows)

so no problem there either.  Looks like you should get a trade-in on
that beta3 :-)

Cheers,            Andrew.
-- 
_____________________________________________________________________           Andrew McMillan, e-mail:
Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267