Postgres type "{field type}" is only a shell

Question

I use Django & postgres. My migration contains something like this :

db.create_table('location_locationlevel', (
        ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
        ('name_0', self.gf('django.db.models.fields.CharField')(max_length=75, null=True, blank=True)),
        ('name_1', self.gf('django.db.models.fields.CharField')(max_length=75, null=True, blank=True)),
        ('name_2', self.gf('django.db.models.fields.CharField')(max_length=75, null=True, blank=True)),
        ('name_3', self.gf('django.db.models.fields.CharField')(max_length=75, null=True, blank=True)),
        ('name_4', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)),
        ('geom', self.gf('django.contrib.gis.db.models.fields.MultiPolygonField')()),
    ))

When I run migration, I get error like below:

django.db.utils.DatabaseError: type "geometry" is only a shell
LINE 1: ...ABLE public.location_locationlevel ADD COLUMN geom geometry 
                                                         ^
QUERY:  ALTER TABLE public.location_locationlevel ADD COLUMN geom geometry 
CONTEXT:  PL/pgSQL function addgeometrycolumn(character varying,character varying,character varying,character varying,integer,character varying,integer)

Did anyone have experienced something like this before, and what was the solution?

Postgres type "{field type}" is only a shell

1 Answers