summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/postgres.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-10-04 03:19:38 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-10-04 03:19:38 +0000
commitf67fcd182277e6347ad0b97e265ccb24a4e5bd49 (patch)
tree9f25ed7aa0a47b1075f03ba47fdd756815e7d7b8 /lib/sqlalchemy/databases/postgres.py
parentc25fa30febb2fc7ac21fe1379ee03595c7c6a8b6 (diff)
downloadsqlalchemy-f67fcd182277e6347ad0b97e265ccb24a4e5bd49.tar.gz
- move PG RETURNING tests to postgres dialect test
- added server_version_info() support for PG dialect - exclude PG versions < 8.4 for RETURNING tests
Diffstat (limited to 'lib/sqlalchemy/databases/postgres.py')
-rw-r--r--lib/sqlalchemy/databases/postgres.py7
1 files changed, 7 insertions, 0 deletions
diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py
index 990140c89..74b9e6f43 100644
--- a/lib/sqlalchemy/databases/postgres.py
+++ b/lib/sqlalchemy/databases/postgres.py
@@ -382,6 +382,13 @@ class PGDialect(default.DefaultDialect):
""" % locals()
return [row[0].decode(self.encoding) for row in connection.execute(s)]
+ def server_version_info(self, connection):
+ v = connection.execute("select version()").scalar()
+ m = re.match('PostgreSQL (\d+)\.(\d+)\.(\d+)', v)
+ if not m:
+ raise exceptions.AssertionError("Could not determine version from string '%s'" % v)
+ return tuple([int(x) for x in m.group(1, 2, 3)])
+
def reflecttable(self, connection, table, include_columns):
preparer = self.identifier_preparer
if table.schema is not None: