ckan / ckan/ckanext-spatial

Incompatible with `db clean`

Open
#182 1 comment 3 reactions 0 assignees View on GitHub
Dominant language
XSLT
Stars
136
Forks
207
PR merge metrics
No merged PRs in 30d

Description

With this plugin enabled using the core CKAN command to clear the database becomes impossible for a couple of reasons.

1. The tables it tries to delete cannot be deleted until the postgis extension is dropped (`DROP EXTENSION postgis; DROP EXTENSION postgis_topology;`)
2. The clear cannot finish as the extension tries to create missing tables on load, but cannot complete this midway during the clear process.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the core CKAN database-clean command and the plugin's PostgreSQL/PostGIS extension setup described in the issue. Reproduce the failure with the plugin enabled, then trace why table deletion and extension initialization conflict during the clear. Done means the database-clean command completes successfully without requiring manual extension drops.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.