Can someone explain me about the exception handling in postgresql. Iam not understanding the scope of a exception block. The exact confusion that iam facing is as follows: I have a procedure as follows BEGIN EXECUTE an update statement
EXECUTE an insert statement EXCEPTION WHEN integrity_conatraint_violation THEN RAISE NOTICE END; This procedure is called within another procedure. Now when an exception is caught the updates are also getting rolled back. I need the exception block to work only for the insert statement. But if i dont write the exception block the whole program stops. Any suggestions? Thanks Sam -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
