Opened 5 years ago

Closed 5 years ago

#31248 closed Cleanup/optimization (fixed)

Missing whitespace in SQL generated for PostGIS indexed with USING.

Reported by: Hannes Ljungberg Owned by: Hannes Ljungberg
Component: GIS Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Creating an index as:

class City(models.Model):
    point = models.PointField(geography=True)

    class Meta:
        index = Index(fields=["point"])

Will generate the valid but not so pretty CREATE INDEX statement:

CREATE INDEX "geogapp_city_point_id" ON "geogapp_city"USING GIST ("point")

The following would be expected:

CREATE INDEX "geogapp_city_point_id" ON "geogapp_city" USING GIST ("point")

Change History (3)

comment:2 by Mariusz Felisiak, 5 years ago

Has patch: set
Summary: Missing whitespace in SQL generated for PostGIS IndexMissing whitespace in SQL generated for PostGIS indexed with USING.
Triage Stage: UnreviewedAccepted

comment:3 by Mariusz Felisiak <felisiak.mariusz@…>, 5 years ago

Resolution: fixed
Status: assignedclosed

In adcf1a73:

Fixed #31248 -- Added missing space before USING SQL on PostGIS.

Note: See TracTickets for help on using tickets.
Back to Top