Yes , I am sure it is not trigger recursion.
- Original Message -
From: "Pavel Stehule" <[EMAIL PROTECTED]>
To: "Praveen" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2008 3:03 PM
Subject: Re: [PERFORM] Trigger is not firing
t; THEN
> BEGIN
> INSERT INTO table2(cols)
> VALUES(values);
> IF NOT FOUND THEN
> NULL;
> END IF;
> EXCEPTION
> WHEN OTHERS
> THEN
> NULL;
> END;
> END IF;
> END IF;
> RETURN NULL;
> END; $BODY$
> LANGUAGE 'plpgsql' VOLATILE;
>
ALUES(values);
IF NOT FOUND THEN
NULL;
END IF;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
END IF;
END IF;
RETURN NULL;
END; $BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION trigger1();
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
T
Praveen wrote:
>
> Hi All,
> I am having a trigger in table, If I update the the table manually
> trigger is firing immediately(say 200ms per row), But if I update the
> table through procedure the trigger is taking time to fire(say 7 to 10
> seconds per row).
>
> Please tell me what kind o
am Mon, dem 14.07.2008, um 12:04:49 +0530 mailte Praveen folgendes:
>
> Hi All,
> I am having a trigger in table, If I update the the table manually trigger
> is firing immediately(say 200ms per row), But if I update the table through
> procedure the trigger is taking time to fire(say 7 to 1
