Error message with all violation of restrictions in postgres

Question

I am creating a node application using node pg client, and since this is a simple application, I do not use application validation and do not apply only postgres restrictions to protect data integrity and display insert and update errors.

Using the pg client, I get only one restriction violation at once, even if multiple violations occur.

Is it possible to install postgres in order to emit all violations when violating the rights to insert error?

Answer 1

Is it possible to install postgres in order to emit all violations when violating the rights to insert error?

Not with PostgreSQL, no, because the first violation causes an error that aborts the transaction.

PostgreSQL , PostgreSQL.

, ; .