app/django/db/backends/postgresql/version.py
author Lennard de Rijk <ljvderijk@gmail.com>
Thu, 04 Jun 2009 20:21:15 +0200
changeset 2382 3a6302dd346b
parent 323 ff1a9aa48cfd
permissions -rw-r--r--
Added link to edit the Document on the Document's public page. This link will only show if the user is allowed to edit the document. Fixes issue 271. Update issue 271 Owner: ljvderijk

"""
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)