Re: [SQL] Sequence of SQL command execution involving triggers and stored procedures.

2004-09-18 Thread Tom Lane
"Omkar Rath" <[EMAIL PROTECTED]> writes: > Say there is a stored procedure i.e FUNCTION sp_foo(...) which has say, > SQL commands (any of SELECT,INSERT,UPDATE,DELETE) in its body, say S1 > followed by S2 then S3 Furthermore, execution of statement S2 > results in trigger functions getting invok

[SQL] Sequence of SQL command execution involving triggers and stored procedures.

2004-09-18 Thread Omkar Rath
Title: Message I am observing the following:   Say there is a stored procedure i.e FUNCTION sp_foo(...) which has say, SQL commands (any of SELECT,INSERT,UPDATE,DELETE) in its body, say S1 followed by S2 then S3 Furthermore, execution of statement S2 results in trigger functions getting