Mgiyuk

Postgres 11 - COMMIT Procedure With the recent update of Postres 11. It now supports stored procedures. Transactions are finally supported in stored procedures in Postgres. However, I have been trying to perform a commit within a procedure with no luck. CREATE OR REPLACE PROCEDURE test_update( IN pid character, IN pcategoryname character varying, IN pwebcode character varying, IN porder numeric, IN pupdatedby character varying, IN pupdateddate timestamp without time zone, IN plang character varying, INOUT cresults refcursor) LANGUAGE plpgsql AS $BODY$ DECLARE cnt bigint; rtnCode char(1); BEGIN cresults := 'cur'; BEGIN update test_table set FCATEGORYNAME = pCategoryName, FWEBCODE = pWebCode, FORDER = pOrder, FUPDATEDBY = pUpdatedBy, FUPDATEDDATE = pUpdatedDate, ...