app/django/db/backends/postgresql/version.py
author Lennard de Rijk <ljvderijk@gmail.com>
Wed, 26 Aug 2009 18:31:19 +0200
changeset 2811 c8901482dc9c
parent 323 ff1a9aa48cfd
permissions -rw-r--r--
Added timeline_logic keyword argument to Program logic. This will allow us to track which Timeline logic belongs to which each Program.

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