is postgresql nested exception possible?

Question

i am using postgrest exception in function 'public.main_function'. in exception 'others', i also use sub functions to save my log data.

but my sub function 'public.something_went_wrong_log_creation' might be error sometimes.

how can i add exception (nested exception) in exception 'others' below?

    CREATE OR REPLACE FUNCTION public.main_function(request json)
  RETURNS integer AS
$BODY$

BEGIN
    -- statement 1
    -- statement 2
    -- statement 3

    RETURN 1;

EXCEPTION
    -- SOMETHING WENT WRONG
    WHEN others
    THEN
        -- LOG SOMETHING WENT WRONG
        PERFORM public.something_went_wrong_log_creation();

        RETURN 0;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE

    CREATE OR REPLACE FUNCTION public.something_went_wrong_log_creation()
  RETURNS integer AS
$BODY$

BEGIN
    -- statement 1
    -- statement 2
    -- statement 3

    RETURN 1;

EXCEPTION
        -- SOMETHING WENT WRONG
        WHEN others
        THEN
            RETURN 0;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE

Łukasz Kamiński · Accepted Answer · 2018-04-30 06:38:18Z

4

You can use subblock and wrap your exception handling code in it.

CREATE OR REPLACE FUNCTION public.main_function(request json)
  RETURNS integer AS
$BODY$

BEGIN
    -- statement 1
    -- statement 2
    -- statement 3

    RETURN 1;

EXCEPTION
    -- SOMETHING WENT WRONG
    WHEN others
    THEN
        BEGIN
          -- LOG SOMETHING WENT WRONG
          PERFORM public.something_went_wrong_log_creation();

          RETURN 0;
        EXCEPTION
             WHEN others
             THEN
               RETURN -1;
        END;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE

answered Apr 30, 2018 at 6:38

Łukasz Kamiński

6,0301 gold badge26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

is postgresql nested exception possible?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related