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

Lorenzo Peña

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?

GwynBleidD

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.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

ProgrammingError: relation "django_site" does not exist

django.db.utils.ProgrammingError: relation already exists on OenBSD vps

django.db.utils.OperationalError: FATAL: role "django" does not exist

django.db.utils.ProgrammingError: relation "bot_trade" does not exist

django.db.utils.ProgrammingError: Table doesn't exist

"django.db.utils.ProgrammingError: relation "auth_user" does not exist" Django V2.0

Docker - psql: django.db.utils.OperationalError: FATAL: role "admin" does not exist

ProgrammingError: relation "django_session" does not exist

Connecting Django to Postgres: django.db.utils.OperationalError: FATAL: database "DATABASENAME" does not exist

django.db.utils.ProgrammingError: relation "django_content_type" does not exist

django.db.utils.ProgrammingError: Could not load : column "" of relation "" does not exist

django.db.utils.ProgrammingError: (1146, "Table 'med_portal.Custparent' doesn't exist")

How to convert a column with type int4range to an integer on PostgreSQL 9.4?

django.db.utils.ProgrammingError: column calculator_calculation._id does not exist using heroku and djongo

PostgreSQL unnest, int4range with where clause

django.db.utils.ProgrammingError: syntax error at or near "FUNCTION"

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

django.db.utils.OperationalError: FATAL: database does not exist (postgres / deploy to digitalocean)

Django test fails with 'django.db.utils.ProgrammingError: relation "django_content_type" does not exist'

PostgreSQL - CREATE TABLE with int4range constraint

django.db.utils.ProgrammingError: relation "..." does not exist

Django Rest Framework "django.db.utils.ProgrammingError: relation "patient" does not exist"

django.db.utils.ProgrammingError: column am.amcanorder does not exist

One more "django.db.utils.ProgrammingError: relation "device_gclouddevice" does not exist"

ArrayField of DateTimeField raises "django.db.utils.ProgrammingError: cannot cast type timestamp with time zone to timestamp with time zone[]"

django.db.utils.ProgrammingError: relation "company_company" does not exist when running makemigrations

django.db.utils.ProgrammingError: relation does not exist with recursive model

django/mysql table not found - django.db.utils.ProgrammingError: (1146, "Table 'trustline.authentication_user' doesn't exist")

Django - ProgrammingError - column does not exist