10799_geojsongeometry_featureid can't be reversed

[jacobtylerwalls]

From a fully migrated 7.6/8.0.dev db:

python manage.py migrate models 10999_update_principaluser

django.db.utils.OperationalError: cannot ALTER TABLE "geojson_geometries" because it has pending trigger events

I've found that calling refresh_geojson_geometries() inside a RunSQL operation is pretty fragile because the function truncates a table and disturbs the per-migration transaction. Things usually work if you isolate the single migration operation involving that function into its own file.

That said, 7.6 has already shipped, so we can't easily insert a new migration into the middle of the history. We could cheat a little bit and just move this AddField operation into the previous migration and a comment explaining what/why:

arches/arches/app/models/migrations/10799_geojsongeometry_featureid.py

Lines 188 to 192 in 8ed87f3

	migrations.AddField(
	model_name="geojsongeometry",
	name="featureid",
	field=models.UUIDField(blank=True, null=True, serialize=False),
	),

[whatisgalen]

fixed by #11569