adding an "already exists" catch for CREATE DOMAIN

1 files changed, 6 insertions, 2 deletions

diff --git a/test/dialect/postgres.py b/test/dialect/postgres.py
index f80ddcadd..221f7660a 100644
--- a/test/dialect/postgres.py
+++ b/test/dialect/postgres.py
@@ -11,8 +11,12 @@ class DomainReflectionTest(AssertMixin):
     @testing.supported('postgres')
     def setUpAll(self):
         con = testbase.db.connect()
-        con.execute('CREATE DOMAIN testdomain INTEGER NOT NULL DEFAULT 42')
-        con.execute('CREATE DOMAIN alt_schema.testdomain INTEGER DEFAULT 0')
+        try:
+            con.execute('CREATE DOMAIN testdomain INTEGER NOT NULL DEFAULT 42')
+            con.execute('CREATE DOMAIN alt_schema.testdomain INTEGER DEFAULT 0')
+        except exceptions.SQLError, e:
+            if not "already exists" in str(e):
+                raise e
         con.execute('CREATE TABLE testtable (question integer, answer testdomain)')
         con.execute('CREATE TABLE alt_schema.testtable(question integer, answer alt_schema.testdomain, anything integer)')
         con.execute('CREATE TABLE crosschema (question integer, answer alt_schema.testdomain)')