Re: [GENERAL] Stored procedure failure

2004-08-27 Thread Tom Lane
Michal Hlavac <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I can't reproduce a crash here, but perhaps that's because you have not >> supplied any sample data... > I attached file with data, where it fails... Thanks. It turns out the main reason I couldn't reproduce it was I was testing in C

Re: ltree bug handling nulls (was [GENERAL] Stored procedure failure)

2004-08-26 Thread Richard Huxton
Michal Hlavac wrote: Richard Huxton wrote: Looking at the 8.0beta source, the functions (...ltree_isparent) are all marked strict so they should just return null on a null parameter. What happens if you set my_path to some non-null but un-matched value before the problem line? When my_path have

Re: [GENERAL] Stored procedure failure

2004-08-26 Thread Michal Hlavac
Richard Huxton wrote: Looking at the 8.0beta source, the functions (...ltree_isparent) are all marked strict so they should just return null on a null parameter. What happens if you set my_path to some non-null but un-matched value before the problem line? When my_path have non-null value, ever

Re: [GENERAL] Stored procedure failure

2004-08-26 Thread Michal Hlavac
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 conne

Re: [GENERAL] Stored procedure failure

2004-08-26 Thread Richard Huxton
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 unexpec

[GENERAL] Stored procedure failure

2004-08-26 Thread Michal Hlavac
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 pr