- Notifications
You must be signed in to change notification settings - Fork1.2k
Can the error severity be removed from the error message created by Postgresql#1268
Uh oh!
There was an error while loading.Please reload this page.
Uh oh!
There was an error while loading.Please reload this page.
-
Is there a way to remove the "ERROR:" from the error message that postgresql sends? Adding a sample error message :
All SQLException thrown by Postgres seems to be starting with "ERROR:" and I am exploring options if it can be removed through superuser. I have raised a similar questionhere. Any suggestions or confirmation if it can or cannot be done is appreciated. |
BetaWas this translation helpful?Give feedback.
All reactions
Replies: 1 comment 1 reply
-
The best I can find ishttps://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-MIN-ERROR-STATEMENT -- ie, setting There does appear to be a JSON format for the logs (https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG) which might be interesting and allow you to better parse/filter these messages with another tool? |
BetaWas this translation helpful?Give feedback.
All reactions
-
actually, its a big application with many sql messages, and removing "ERROR:" keyword from the message after SQLException is caught is the last resort. on debugging, I find that the
|
BetaWas this translation helpful?Give feedback.