Annotation: transactions.restrict_delete_trigger

CREATE OR REPLACE FUNCTION transactions.restrict_delete_trigger()
RETURNS trigger

Information: transactions.restrict_delete_trigger

Schema	transactions
Function Name	restrict_delete_trigger
Arguments
Owner	postgres
Result Type	trigger
Description

Implementation: transactions.restrict_delete_trigger

CREATE OR REPLACE FUNCTION transactions.restrict_delete_trigger()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF TG_OP='DELETE' THEN
        RAISE EXCEPTION 'Deleting a transaction is not allowed. Mark the transaction as rejected instead.';
    END IF;
END
$function$