summaryrefslogtreecommitdiff
path: root/django/db/backends/postgresql/version.py
diff options
context:
space:
mode:
authorMalcolm Tredinnick <malcolm.tredinnick@gmail.com>2008-08-12 06:31:29 +0000
committerMalcolm Tredinnick <malcolm.tredinnick@gmail.com>2008-08-12 06:31:29 +0000
commit6bebb23318c5a2195a89a7154118cfc5ea19bba7 (patch)
tree942a07924c6496096e19ae3bc83483786b73372c /django/db/backends/postgresql/version.py
parent97da73a98cfe5e5545b7d997e6078c8571115a76 (diff)
downloaddjango-6bebb23318c5a2195a89a7154118cfc5ea19bba7.tar.gz
Do not use savepoints with PostgreSQL prior to 8.0.
git-svn-id: http://code.djangoproject.com/svn/django/trunk@8317 bcc190cf-cafb-0310-a4f2-bffc1f526a37
Diffstat (limited to 'django/db/backends/postgresql/version.py')
-rw-r--r--django/db/backends/postgresql/version.py18
1 files changed, 18 insertions, 0 deletions
diff --git a/django/db/backends/postgresql/version.py b/django/db/backends/postgresql/version.py
new file mode 100644
index 0000000000..e14d791b07
--- /dev/null
+++ b/django/db/backends/postgresql/version.py
@@ -0,0 +1,18 @@
+"""
+Extracts the version of the PostgreSQL server.
+"""
+
+import re
+
+VERSION_RE = re.compile(r'PostgreSQL (\d+)\.(\d+)\.')
+
+def get_version(cursor):
+ """
+ Returns a tuple representing the major and minor version number of the
+ server. For example, (7, 4) or (8, 3).
+ """
+ cursor.execute("SELECT version()")
+ version = cursor.fetchone()[0]
+ major, minor = VERSION_RE.search(version).groups()
+ return int(major), int(minor)
+