Re: Stored procedure failure - Mailing list pgsql-general

From Michal Hlavac
Subject Re: Stored procedure failure
Date
Msg-id 412DB854.4080907@medium13.sk
Whole thread Raw
In response to Stored procedure failure  (Michal Hlavac <hlavki@medium13.sk>)
List pgsql-general
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@medium13.sk ][ http://www.medium13.sk ]
[ icq:94900232 ][ callto://hlavki ]

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Stored procedure failure
Next
From: Michal Hlavac
Date:
Subject: Re: Stored procedure failure