Question 114184 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – How to check for custom Postgres exceptions raised via RAISE EXCEPTION in Golang?

I’m using Postgres with Golang via pgx

I’ve a trigger function something like the following:

CREATE OR REPLACE FUNCTION foo() 
RETURNS TRIGGER AS
$$
BEGIN
    IF (bar = 'baz') THEN
        -- something
    ELSE
        RAISE EXCEPTION 'oops error';
    END IF;
    RETURN NEW;
END;
$$
LANGUAGE plpgsql;

How do I check for oops error in Go code?

The way I’m doing it now is:

errOops := errors.New("ERROR: oops error (SQLSTATE P0001)")
err := myDBFunc()
if errors.Is(err, errOops) {

}

But I wonder if there’s a better way other than relying on the hardcoded message.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Should have read the Wiki: Error Handling in pgx

    So I can do:

    var pgErr *pgconn.PgError
if errors.As(err, &pgErr) && pgErr.Code == "P0001" {

}

    or something similar.


  2. 0

    You can find that information in appendix A of the documentation: it will be a raise_exception, and the SQLSTATE is P0001.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search