Question : According to the docs, there are options to RAISE called TABLE and COLUMN. However , if I explicitly […]
Can stable (or immutable) functions call volatile functions?
Question : The PostgreSQL documentation states: Any function with side-effects must be labeled VOLATILE… Consider the following function: CREATE OR […]
MongoDB Shard – Disable Cursor timeout
Question : I’m using an sharded-cluster(Mongo version 2.4.1) with a java application. After a specific time (10 minutes or more) […]
How to catch and handle only specific Oracle exceptions?
Question : From this and this i guess, that there is no predefined Named System Exceptions for ORA-00955. How can […]
exception: hosts cannot switch between localhost and hostname
Question : I created a replication set. I added localhost in the set in the beginning, but when I try […]
Is it possible to raiserror within a For Delete Trigger that rolls back the deletes
Question : There is a claim at the end of this accepted answer that if an error occurs within a […]
Using EXCEPTION to ignore duplicates during bulk inserts
Question : In pq 9.3.5, I’m importing records from an external source where duplicates are VERY rare, but they do […]
Insert values to table only if first Insert was successful
Question : Is there a way I could check the status of an insert query whether it was successful or […]
Is using dbms_utility.format_error_stack to filter errors in the exception block a bad idea?
Question : I’m trying to handle two different exceptions could trigger in an external table that reads a CSV. The […]
INSERT trigger dying with with #target columns not equal to #expressions, but they are equal
Question : I am trying to write my first trigger. It is an insert trigger as follows: <b>Fatal error</b>: postgres7 […]