Hello, I've a table with 1 primary key and 1 unique index.
I would like to handle differently the duplicate key violations depending on which constraints are affected. (Within a plpgsql CATCH block, using SQLERRM). It seems, that when both constraints would be violated, the exception is always about the primary key. Can I rely on that or should I expect the exception order being random ? Thanks, Marc Mamin