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)
-> Seq Scan 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(at)cat-it(dot)co(dot)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