Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Import into PostGIS fails due to capital letter #19845

Closed
qgib opened this issue Nov 6, 2014 · 2 comments
Closed

Import into PostGIS fails due to capital letter #19845

qgib opened this issue Nov 6, 2014 · 2 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms

Comments

@qgib
Copy link
Contributor

qgib commented Nov 6, 2014

Author Name: Spencer Gardner (@spencerrecneps)
Original Redmine Issue: 11585
Affected QGIS version: master
Redmine category:processing/qgis
Assignee: Victor Olaya


When using the Import into PostGIS tool, if I give a table name that starts with a capital letter the tool fails while creating the spatial index:

@message: relation "scratch.tablename" does not exist QUERY: CREATE INDEX sidx_Tablename ON scratch.Tablename USING GIST(geom) See log for more details@

It appears the script doesn't honor the initial capital letter when trying to create the index.

Steps to reproduce:
1 - Open "Import into PostGIS" processing tool
2 - Fill out appropriate fields, specifying a table name that starts with a capital letter
3 - Run the tool

Expected behavior is that the tool successfully creates a new table with a spatial index.

@qgib
Copy link
Contributor Author

qgib commented Nov 6, 2014

Author Name: Giovanni Manghi (@gioman)


  • version was changed from 2.6.0 to master
  • os_version was changed from 7 to
  • operating_system was changed from Windows 64-bit to

@qgib
Copy link
Contributor Author

qgib commented Sep 30, 2015

Author Name: Victor Olaya (@volaya)


Fixed in changeset "ae71e1f098e00f2d7674373be66461a594affcad".


  • status_id was changed from Open to Closed

@qgib qgib added Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms labels May 25, 2019
@qgib qgib closed this as completed May 25, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms
Projects
None yet
Development

No branches or pull requests

1 participant