[ERROR ] Unknown exception: bad allocation

Поиск
Список
Период
Сортировка
От stefan0n
Тема [ERROR ] Unknown exception: bad allocation
Дата
Msg-id 413518.68983.qm@web112004.mail.gq1.yahoo.com
обсуждение исходный текст
Список pgadmin-support
Dear Support

I'm not an expert and I'm trying to use a function I wrote in postgresql that doesn't work as I expected.
so I'm testing a part of the function in a small pgscript:

set @i = 9.95;
set @h = 10000;
set @e = 2518825.53769669;
set @n = 4557597.6818137;


select  id, ccod, distanza,        dev.fun_i_d_blake(@i::double precision, distanza::double precision, @h::double
precision)as intens,       x_coord, y_coord from (   select id, ccod, x_coord, y_coord,
st_distance(ST_GeometryFromText('POINT('|| x_coord || ' ' || y_coord || ')', 26592),
ST_GeometryFromText('POINT('|| @e || ' ' || @n || ')', 26592) ) as distanza   from dev.dist_int ) as calcdist; 


if I execute the content of the script without parameters, as SQL it works.
when I try to execute this script after some time I have:

[QUERY    ] select  id, ccod, distanza,                    dev.fun_i_d_blake(9.95::double precision, distanza::double
precision,10000::double precision) as intens,                   x_coord, y_coord             from             (
     select id, ccod, x_coord, y_coord,                 st_distance(ST_GeometryFromText('POINT ('|| x_coord || ' ' ||
y_coord|| ')', 26592),                            ST_GeometryFromText('POINT( '|| 2518825.53769669 || ' ' ||
4557597.6818137|| ')', 26592) ) as distanza               from dev.dist_int             ) as calcdist 
[ERROR    ] Unknown exception:
bad allocation

this error. can someone help me? thank you!
||
|| stefano nardone
||
||email: stefan0n@yahoo.com
||






В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dmitry Samokhin"
Дата:
Сообщение: Re: pgAgent Windows service startup time
Следующее
От: Pedro Martins
Дата:
Сообщение: Please help me "error 42704"