Common Exceptions

SQLStates for some common exceptions:

• deadlock

  40001

• foreign key violation

  23503

• check constraint violation

  23513

• duplicate value violating unique or primary key constraint

  23505

• duplicate value violating unique index

  23505

• truncation error

  22001

• user authorization error

  08004

• user authentication error (no permission to access database)

  04501

• user authentication error (no write access)

  22502