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: | Raw Message | Whole Thread | 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 |