pgerror

Documentation

Overview

Package pgerror provides utilities for working with PostgreSQL errors.

Index

• Constants
• func Is(err error, codes ...string) bool
• func Retry(ctx context.Context, db *sql.DB, fn func(*sql.Tx) error, codes ...string) error

Constants

const (
	// CodeUniqueViolation is the PostgreSQL error code for "unique_violation".
	CodeUniqueViolation = "23505"

	// CodeUndefinedTable is the PostgreSQL error code for "undefined_table".
	CodeUndefinedTable = "42P01"
)

https://www.postgresql.org/docs/11/errcodes-appendix.html

Functions

func Is

func Is(err error, codes ...string) bool

Is returns true if err is a PostgreSQL error with one of the given codes.

func Retry

func Retry(
	ctx context.Context,
	db *sql.DB,
	fn func(*sql.Tx) error,
	codes ...string,
) error

Retry executes fn within a transaction, retrying it if the error is one of the given codes.