Re: [BUGS] Failing backend on plpgsql function

2001-05-23 Thread Tom Lane
Ondrej Palkovsky <[EMAIL PROTECTED]> writes: > I have the following function. When the function is executed and it gets > to the 'IF NOT FOUND', the backend gets restarted. Is this in 7.1.1? There's an embarrassing bug in 7.1.1 --- plpgsql coredumps on a SELECT that returns no rows. It's fixed

[BUGS] Failing backend on plpgsql function

2001-05-22 Thread Ondrej Palkovsky
I have the following function. When the function is executed and it gets to the 'IF NOT FOUND', the backend gets restarted. I've read that the exception handling is not perfect in Postgres but this seems to me too hard behaviour for a badly written function. CREATE FUNCTION attach_message(int8,i