From: | zzia88(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14241: i want to do commit and rollback in one plpgsql block.. |
Date: | 2016-07-11 07:32:04 |
Message-ID: | 20160711073204.1416.90740@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14241
Logged by: Zubair Alam
Email address: zzia88(at)gmail(dot)com
PostgreSQL version: 9.5.3
Operating system: windows7-x64(64 bit)
Description:
CREATE OR REPLACE FUNCTION DELROLL()
RETURNS INT AS $V_CHOICE$
BEGIN
IF V_CHOICE=1 THEN
DELETE FROM ITEMS
WHERE itemid=4;
--DBMS_OUTPUT.PUT_LINE('EMPLYEE RECORD DELETED
SUCESSFULLY');
END IF;
IF V_CHOICE=2 THEN
ROLLBACK;
COMMIT;
---DBMS_OUTPUT.PUT_LINE('ROLL BACK COMPLETED SUCESSFULLY');
END IF;
RETURN V_CHOICE;
END;
$V_CHOICE$
LANGUAGE PLPGSQL;
when i enter my choice 2 i.e for rollback and commit then that time this
error is generating.
ERROR: current transaction is aborted, commands ignored until end of
transaction block
********** Error **********
ERROR: current transaction is aborted, commands ignored until end of
transaction block
SQL state: 25P02
please give me perfect solution for using commit and rollback in one
plpgsql program block.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2016-07-11 09:03:53 | Re: [BUGS] Where clause in pg_dump: need help |
Previous Message | David G. Johnston | 2016-07-11 01:33:23 | Re: [BUGS] Where clause in pg_dump: need help |