| From: | Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | postgres <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problems with genetic optimizer |
| Date: | 2000-10-26 06:25:26 |
| Message-ID: | 39F7CE56.60E990DA@bvv.bayern.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> No, I'm sorry, but there is no core file.
>
> You're probably running one of those setups where the postmaster is
> started with a ulimit setting that prevents core dumps. You might
> want to look into changing that for future debugging purposes.
Yes, you are right, I changed it in /etc/profile.
>
> > query: select * from box_tmp where ebre &&
> > ('(470758.555,354028.145),(470758.525
> > ,354028.115)'::box);
> > ProcessQuery
> > /opt/local/DWH/bin/postmaster: reaping dead processes...
> > /opt/local/DWH/bin/postmaster: CleanupProc: pid 679 exited with status
> > 11
>
> Now that I think about it, are there any NULL entries in box_tmp.ebre?
> The box_overlap function, like practically all of the geometric
> operators :-(, doesn't defend itself against NULL inputs in 7.0 and
> earlier releases.
YES!! I deleted the NULL entries. Now it works. Thanks!!!
Peter
--
Bezirksfinanzdirektion Muenchen
Vermessungsabteilung
.........................................................
Peter Keller : Tel: (+49) 089-2190-2594
Vermessungsrat : Fax: (+49) 089-2190-2459
Alexandrastr. 3 : mailto:Peter(dot)Keller(at)bvv(dot)bayern(dot)de
80538 Muenchen : web: http://www.bayern.de/vermessung
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DaVinci | 2000-10-26 09:23:54 | Array size and iterate... |
| Previous Message | Cristóvão B. B. Dalla Costa | 2000-10-26 05:19:57 | postgresql && clusters |