Skip to content
This repository has been archived by the owner on Jun 4, 2020. It is now read-only.

Syntax Error in Delete Trigger in PostGIS checkout #45

Closed
eg-novelt opened this issue Jun 22, 2016 · 3 comments
Closed

Syntax Error in Delete Trigger in PostGIS checkout #45

eg-novelt opened this issue Jun 22, 2016 · 3 comments

Comments

@eg-novelt
Copy link
Contributor

To reproduce the problem, create a PostGIS checkout, then try to delete some geometries. There will be a syntax error in the delete trigger.

The problem is here:

https://github.com/Oslandia/qgis-versioning/blob/master/versioning_base.py#L1479

The hardcoded schema in the code "epanet" does not exist. Seems like it should be the variable schema, like so

"SELECT "+cols+", "+hcols+" FROM "+schema+"."+table+" "

instead of

"SELECT "+cols+", "+hcols+" FROM epanet."+table+" "

Thanks

@vmora
Copy link
Contributor

vmora commented Jun 22, 2016

Hi, thanks for reporting and finding the bug.

Would you mind submitting a PR ?

@eg-novelt
Copy link
Contributor Author

PR created:

#46

Merci pour la réponse rapide

@eg-novelt
Copy link
Contributor Author

This has been fixed by the PR

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants