#21426: No indexes are created on syncdb
--------------------------------+----------------------
Reporter: burton449geo@… | Owner: nobody
Type: Uncategorized | Status: new
Component: GIS | Version: 1.5-rc-2
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
--------------------------------+----------------------
the model is the following:
class Feature(models.Model):
shapefile = models.ForeignKey(Shapefile)
id_relat = models.IntegerField(db_index=True)
geom_point = models.PointField(srid=3857, blank=True, null=True)
geom_multipoint = models.MultiPointField(srid=3857, blank=True,
null=True)
geom_multilinestring = models.MultiLineStringField(srid=3857,
blank=True, null=True)
geom_multipolygon = models.MultiPolygonField(srid=3857, blank=True,
null=True)
geom_geometrycollection = models.GeometryCollectionField(srid=3857,
blank=True, null=True)
objects = models.GeoManager()
def __unicode__(self):
return str(self.id)
the error message on syncdb is the following (translated from french to
english):
c:\mygeosite\geodjango>python manage.py syncdb
Syncing...
Creating tables ...
Creating table shapefile_feature
Installing custom SQL ...
Installing indexes ...
Failed to install index for shapefile.Feature model: ERROR: field « geom
_point » of the relation « shapefile_feature already exists
CONTEXT: instruction SQL « ALTER TABLE public.shapefile_feature ADD
COLUMN geo
m_point geometry(Point, 3857) ┬╗
fonction PL/pgsql addgeometrycolumn(character varying,character
varying,characte
r varying,character varying,integer,character varying,integer,boolean),
line 11
0 à instruction EXECUTE
instruction SQL « SELECT AddGeometryColumn('','',$1,$2,$3,$4,$5, $6) »
fonction PL/pgsql addgeometrycolumn(character varying,character
varying,integer,
character varying,integer,boolean), line 5 à instruction SQL
Installed 0 object(s) from 0 fixture(s)
--
Ticket URL: <https://code.djangoproject.com/ticket/21426>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/065.b7156be70f92e3e3630dc0692c42b9e2%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.
