Hi,
well i just updated the code and found your patch is applied in there and
it's working. may be i missed something while applying your patch.
Regards,
--Asif
On 2/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Asif Ali" <[EMAIL PROTECTED]> writes:
> here is the test case
It works for me:
regr
"Asif Ali" <[EMAIL PROTECTED]> writes:
> here is the test case
It works for me:
regression=# select func();
INFO: sql error msg ex -
INFO: sql error msg ex -
INFO: sql error v_msg ex -
func
--
0
(1 row)
Are you sure you applied the patch correctly? In particular, you'd n
here is the test case
CREATE OR REPLACE FUNCTION func() RETURNS int as $$
BEGIN
RAISE EXCEPTION 'ex -';
EXCEPTION
WHEN OTHERS THEN
RAISE INFO 'sql error msg %',sqlerrm;
DECLARE
v_msg VARCHAR(200) := sqlerrm;
BEGIN
RAISE INFO 'sql error msg %',sqlerrm; -- it show's
RAISE INFO 'sql err
"Asif Ali" <[EMAIL PROTECTED]> writes:
> your patch fixes the crash but instead of displaying the sqlerrm value, it
> is displaying in
> pl block, declared inside exception block.
Hm, not what I see here. Could you submit a test case that does that?
regards, tom lane
--
"Asif Ali" <[EMAIL PROTECTED]> writes:
> I have compiled postgres 8.2.1 with gcc 4.1. and when executed this function
> it crashes the server.
The attached patch (against HEAD) fixes your test case, but please see
whether it fixes your original problem; I'm not 100% confident in it
yet. There see
