Re: Stored procedure failure

Michal Hlavac wrote:

> hello, I have interesting problem...
>
> I have stored procedure, which works good, but only if input is
"correct".
> Correct input is, when $1 is id, which exists in table...
> If I put non exists id, database fall down and restart with this error:
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
>
> I think, that problem is in line:
> FOR tmp_row IN SELECT v_name FROM c_part_cat WHERE v_path @> my_path
> ORDER BY v_path LOOP
> because without them it works well...
>
> Version: 7.4.5 and 7.4.3 (both versions have this problem)

I am sorry... I've got it... my_path cannot be null... ;)

thanx, hlavki

--

[ miso hlavac ][ hlavki(at)medium13(dot)sk ][ http://www.medium13.sk ]
[ icq:94900232 ][ callto://hlavki ]