How to catch postgres error?

Question

PostgreSQL

Hello! Is there any way to catch the postgres error

ActiveRecord::StatementInvalid (PG::CharacterNotInRepertoire: ERROR:  invalid byte sequence for encoding "UTF8": 0xdf 0xd4

and if it happened, render your response in json?

Answer 1

IMHO, errors at the DB level should not fall. The database is the last frontier, and the occurrence of errors at its level is a miscalculation in the application logic. Why not use validations?

Answer 2

In the controller method:

begin
  # здесь находится AR запрос ...
rescue ActiveRecord::StatementInvalid => e
  render( json: { message: "ActiveRecord::StatementInvalid error: #{e.message}" }, status: :bad_request )
  return
end