how do I get PL PGSQL error code in a function?

Question

I am writing a PL/PGSQL function and it produces an error. I want to print the error with RAISE NOTICE statement but I don't know how to get the error code? What variable holds the last error?

This is my sample code:

IF FOUND
THEN
    BEGIN
        insert into app.company(dateinserted,name) values(now(),company_name) returning comnpany_id;
        return company_id;
    EXCEPTION
        WHEN OTHERS THEN
            RAISE NOTICE 'Insert failed with...';
            return -2;
    END;
ELSE
    RETURN -1;
END IF;

This code will return company_id if insert was successful and print the error if it fails.

klin · Accepted Answer · 2016-12-07 04:45:55Z

5

...
EXCEPTION
    WHEN OTHERS THEN
        RAISE NOTICE 'Insert failed with error code %', SQLSTATE;
...

Comments

Gurmokh · Accepted Answer · 2016-12-07 11:57:04Z

1

include SQLERRM to get an error message.

answered Dec 7, 2016 at 11:57

Gurmokh

2,09127 silver badges28 bronze badges

Collectives™ on Stack Overflow

how do I get PL PGSQL error code in a function?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related