Bug report #11585
Import into PostGIS fails due to capital letter
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||19845|
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.