Check error type after running a query

[alejandrozuleta]

Are there predefined error types that I can use to check if the returned error is an specific error, namely PostgreSQL's duplicated key value violation?

For example:

_, err := u.DB.NewInsert().Model(model).Exec(ctx)
if err == bun.DuplicatedKeyValueError {
    // Do something
}

How is this supposed to be handled?

[alejandrozuleta]

It seems there is a way to check specific errors for PostgreSQL, it is documented here:

https://bun.uptrace.dev/postgres/#pgdriver-error