Question : When writing procedures, I occasionally encounter situations in which I want to abort the procedure, even if the […]
Tag: error-handling
Need to Check if a Table Exists Before Deleting a Record
Question : I have the following SQL query in my Ruby app: sql = “DELETE FROM `#{database}`.`table1` WHERE `same_id` = […]
BULK INSERT continue on PRIMARY KEY error
Question : I get a CSV file with a several million records every few days. I need to insert them […]
Is there a way to query all error messages in Postgres?
Question : Postgres has a catalogue of possible error messages here: http://www.postgresql.org/docs/8.2/static/errcodes-appendix.html#ERRCODES-TABLE However, I would like to query this information […]
Impossible to log errors after dooming a transaction within an INSERT-EXEC statement
Question : We have a stored procedure that does some work within a transaction, wrapped within a stored procedure that […]
Pros and Cons of Checking if value exist for unique column or let db raise unique error on inserting
Question : While writing a query other day a thought came to me and have stuck in my mind. What […]
Catching two error messages/Throw into table
Question : My goal is to catch errors from backup jobs into monitoring table. The problem is, that there are […]
Do a lot of error checks affect query performance and is it bad practice?
Question : If I have a stored procedure with a handful of error checks that come before the queries are […]
Make SQL Server Agent retry failed script with Try/Catch
Question : I have a script that has a try catch in it so that if it fails I can […]
How do I make PostgreSQL not log specific errors?
Question : ERROR: deadlock detected at character 13 My PG log is full of this, but the thing is, I […]