* tests/test_transaction.py

	(TransactionTestCase.test_failed_commit): Expect IntegrityError
	instead of OperationalError.

	* psycopg/pqpath.c (exception_from_sqlstate): new function that
	converts an SQLSTATE error code to the corresponding exception
	class.
	(pq_raise): use exception_from_sqlstate() to pick which exception
	to use when working with protocol version 3.
	(pq_complete_error): Let pq_raise() pick an appropriate exception
	rather than forcing OperationalError.

1 files changed, 1 insertions, 1 deletions

diff --git a/tests/test_transaction.py b/tests/test_transaction.py
index 285d5e4..81fe54b 100755
--- a/tests/test_transaction.py
+++ b/tests/test_transaction.py
@@ -62,7 +62,7 @@ class TransactionTestCase(unittest.TestCase):
         curs.execute('INSERT INTO table2 VALUES (2, 42)')
         # The commit should fail, and move the cursor back to READY state
         self.assertEqual(self.conn.status, STATUS_BEGIN)
-        self.assertRaises(psycopg2.OperationalError, self.conn.commit)
+        self.assertRaises(psycopg2.IntegrityError, self.conn.commit)
         self.assertEqual(self.conn.status, STATUS_READY)
         # The connection should be ready to use for the next transaction:
         curs.execute('SELECT 1')