- add a skip for JSONB on pg8000 if we are on 1.10.1 or earlier

2 files changed, 9 insertions, 0 deletions

diff --git a/test/dialect/postgresql/test_types.py b/test/dialect/postgresql/test_types.py
index 36f4fdc3f..b7568ca84 100644
--- a/test/dialect/postgresql/test_types.py
+++ b/test/dialect/postgresql/test_types.py
@@ -2304,6 +2304,7 @@ class JSONBTest(JSONTest):
 
 class JSONBRoundTripTest(JSONRoundTripTest):
     __only_on__ = ('postgresql >= 9.4',)
+    __requires__ = ('postgresql_jsonb', )
 
     test_type = JSONB
 
diff --git a/test/requirements.py b/test/requirements.py
index 4d5869226..67bdfb8a3 100644
--- a/test/requirements.py
+++ b/test/requirements.py
@@ -753,6 +753,14 @@ class DefaultRequirements(SuiteRequirements):
                 )
 
     @property
+    def postgresql_jsonb(self):
+        return skip_if(
+            lambda config:
+            config.db.dialect.driver == "pg8000" and
+            config.db.dialect._dbapi_version <= (1, 10, 1)
+        )
+
+    @property
     def percent_schema_names(self):
         return skip_if(
             [