Re: Server process exited with status 139 (meaning?)
От | Andrew McMillan |
---|---|
Тема | Re: Server process exited with status 139 (meaning?) |
Дата | |
Msg-id | 395743C8.5CC3068B@catalyst.net.nz обсуждение исходный текст |
Ответ на | Re: Server process exited with status 139 (meaning?) (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: