Search code examples
djangopostgresqldjango-migrationsdjango-database

django.db.utils.ProgrammingError: type "int4range" does not exist

First time using PostgreSQL specific database fields, more specifically IntegerRangeField. Using Django 1.8.7, PostgreSQL 9.1.13, Psycopg2 2.6.1 and Python 2.7.3 on a Debian virtual machine. Running the migration that adds the IntegerRangeField to a model raises:

django.db.utils.ProgrammingError: type "int4range" does not exist

Do I have to install any module or extension in PostgreSQL in order to use range fields? (I know there is an extension that must be loaded to use HStoreField)

Am I missing something here?

Solution

  • Range fields in postgresql are available from version 9.2 (as mentioned here, they were introduced in 9.2), so you can't use them on 9.1.13 because they aren't there.