Re: Problems with genetic optimizer
| От | Peter Keller |
|---|---|
| Тема | Re: Problems with genetic optimizer |
| Дата | |
| Msg-id | 39F7CE56.60E990DA@bvv.bayern.de обсуждение исходный текст |
| Ответ на | Problems with genetic optimizer (Peter Keller <peter.keller@bvv.bayern.de>) |
| Список | 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.Keller@bvv.bayern.de
80538 Muenchen : web: http://www.bayern.de/vermessung
В списке pgsql-general по дате отправления: