On Tue, Jul 18, 2006 at 10:46:29AM +0530, Penchalaiah P. wrote: > Can u let me know if at all any system defined variable exists to check > whether insert , update , and delete is successfully executed in a > stored procedure........ > > So that I can perform some steps based on the result of execution if > possible please send me the sample code...............
Depending on what you mean by "successfully executed," see "Obtaining the Result Status" or "Trapping Errors" in the PL/pgSQL documentation (error trapping is available in 8.0 and later). http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
