| From: | zzia88(at)gmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #14240: i want do manual commit not auto_commit. |
| Date: | 2016-07-10 12:38:05 |
| Message-ID: | 20160710123805.1426.27365@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14240
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(V_CHOICE INT)
RETURNS INT AS $V_CHOICE$
BEGIN
IF V_CHOICE=1 THEN
DELETE FROM ITEMS
WHERE itemid=4;
END IF;
IF V_CHOICE=2 THEN
ROLLBACK;
--COMMIT;
END IF;
RETURN V_CHOICE;
END;
$V_CHOICE$
LANGUAGE PLPGSQL;
when i am doing auto commit off the it is giving some internal error.
please check this code with commit.
i want to flash my rollback segment automatically.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Olarte | 2016-07-10 15:22:01 | Re: BUG #14240: i want do manual commit not auto_commit. |
| Previous Message | Peter Eisentraut | 2016-07-09 19:03:34 | Re: BUG #14239: Array of array type reporting |