HHH-9166 - Enhance constraint extractor to be able to examine nested exceptions

This fix will allow the PostgreSQL dialect to parse out constraint name if it needs to descend into a nested exception.