BUG #14240: i want do manual commit not auto_commit.

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.

Responses

Browse pgsql-bugs by date

  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