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 ][ [EMAIL PROTECTED] ][ http://www.medium13.sk ] [ icq:94900232 ][ callto://hlavki ]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
