summaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
Diffstat (limited to 'test')
-rw-r--r--test/dialect/postgresql/test_types.py14
1 files changed, 13 insertions, 1 deletions
diff --git a/test/dialect/postgresql/test_types.py b/test/dialect/postgresql/test_types.py
index fac0f2df8..456efbf92 100644
--- a/test/dialect/postgresql/test_types.py
+++ b/test/dialect/postgresql/test_types.py
@@ -14,7 +14,7 @@ import sqlalchemy as sa
from sqlalchemy.dialects.postgresql import base as postgresql
from sqlalchemy.dialects.postgresql import HSTORE, hstore, array, \
INT4RANGE, INT8RANGE, NUMRANGE, DATERANGE, TSRANGE, TSTZRANGE, \
- JSON, JSONB
+ JSON, JSONB, LTREE, LQUERY, LTXTQUERY
import decimal
from sqlalchemy import util
from sqlalchemy.testing.util import round_decimal
@@ -1052,6 +1052,18 @@ class TimestampTest(fixtures.TestBase, AssertsExecutionResults):
eq_(result[0], datetime.datetime(2007, 12, 25, 0, 0))
+class LTreeTest(fixtures.TestBase, AssertsExecutionResults):
+ __only_on__ = 'postgresql >= 9.1.0'
+ __backend__ = True
+
+ def test_ltree(self):
+ engine = testing.db
+ connection = engine.connect()
+
+ # The Postgresql server must have the LTREE extension enabled.
+ # `CREATE EXTENSION ltree;`
+
+
class SpecialTypesTest(fixtures.TestBase, ComparesTables, AssertsCompiledSQL):
"""test DDL and reflection of PG-specific types """