PostgreSQL: please show exception text not only on INSERT/UPDATE but also on DELETE
Currently if a PostgreSQL trigger raised an exception its text will be shown in Creatio's application only on inserting/updating a record. However if a PSQL trigger raised an exception on deleting, Creatio shows to the user a general non-informative message.
Proposal to make the behaviour consistent and let Creatio show the database exception text also on deletion.
Rationale: we use PostgreSQL triggers which intentionally raise exception in some cases when, by our business logic, operation shall notbe permitted due to some values of fields of the record. Implementing such checks by coding on client-side is not a clean way for us, especially since Creatio is not the only frontend to the DB in our system.
Screenshots:
The good way to inform a user (our exception text raised from PSQL, currently shown only on insert/update):
Not a good way (general non-informative message on delete, our PSQL exception text is swallowed):
Do you like this idea?
Hello Artur,
Thank you for this idea! Indeed there is a problem (not only in PSQL but in Oracle and MS SQL as well) so when you try to delete a record that is connected to another system entity record you will firstly see "Unable to delete selected records" message where you can click on "View details" and see connected system entities records (there are also cases when you won't be able to see those connections, but they are very rare).
Our R&D team already has a task to modify this message and insert more details in it like "You are trying to delete a record that is used in "Entity1, Entity2 etc."". I will also let them know about your community idea so to rise the priority of the main problem created on their end.
Thank you for helping us to make our application better!
Best regards,
Oscar