search

johnpholden / qgis3redistricter

Redistricting for QGIS v3
GNU General Public License v3.0
5 stars 2 forks source link

Plans not saved with PostgreSQL data source #7

Open rgreenwood opened 3 years ago

rgreenwood commented 3 years ago

When using a shapefile for redistricting, the plans appear to be saved in a file named:

_Redistricting Plan.qgis.red in the same directory as the shapefile. But using a PostgreSQL as the data source the plans are not saved. Am I missing something?
johnpholden commented 3 years ago

I don't think you're missing something - saving should be data source-agnostic, but it hasn't been tested with PostgreSQL (just Shapefile, MapInfo, and geodatabase), so it's possible there's something that's not working properly with a PostgreSQL database. Busy upcoming week here but will try and take a look and patch it as soon as possible.

rgreenwood commented 3 years ago

Would it be trying to save the plans to the database or the file system? I don't see any errors in the postgres logs that indicate a fail attempt to write something there.

johnpholden commented 3 years ago

It does both - the plan data is saved to the "district" column directly on the specified vector file. The qgis.red file contains the plan's metadata, such as number of districts, data columns, percentage tolerance, et cetera. So there are potentially two exclusive issues: the data not being written to the PostgreSQL database (if you've used the plugin and things seem to be updating properly that's likely not the case) and the plan metadata not being saved to disk.

If only one of these is the error, the latter is less of an issue, since you can just set up the plan again from scratch and the data will still be saved on your selected file, though I want to make clear it's still an issue as it's rather annoying. If it's an error writing to a PostgreSQL database, that's likely handled by QGIS and not the plugin, but I'll still have a look.

On Sun, 5 Sept 2021 at 17:48, Richard Greenwood @.***> wrote:

Would it be trying to save the plans to the database or the file system? I don't see any errors in the postgres logs that indicate a fail attempt to write something there.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/johnpholden/qgis3redistricter/issues/7#issuecomment-913261672, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALEYIATN4BGY3YIEWMCQXALUAQFWFANCNFSM5DPAI5LQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

rgreenwood commented 3 years ago

The data is saved to the PostgreSQL database, it's the metadata that's not saved.