DBManager doesn't allow to load PostGis Raster with a number as first character

[qgib]

Author Name: Loïc BARTOLETTI (@lbartoletti)
Original Redmine Issue: 13607
Affected QGIS version: 2.8.3
Redmine category:db_manager

---

DBManager doesn't allow to load PostGis Raster with a number as first character. The same Raster into PostGis can't be load if the first character of table name is a digit.

Here, some tests with table name:

rast : allowed
2rast : unallowed
_rast : allowed

[qgib]

Author Name: Sebastian Dietrich (Sebastian Dietrich)

---

This is a GDAL bug. GDAL does not quote identifiers, usernames and passwords. Instead it actually removes quotes when they are given in the connection string.

While rast does not need quoting, 2rast needs to be quoted. So @select * FROM rast@ works but @select * FROM 2rast@ gives a syntax error.

To reproduce run on the commandline:

gdalinfo "PG: dbname=database host=127.0.0.1 user=username password=pass port=5432 mode=2 schema=public column=rast table=2rast"

Note that the following are related errors:

• schemanames/layernames/columnnames containing uppercase letters
• schemanames/layernames/columnnames containing spaces
• schemas/layers/columns with a "keyword":http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html as a name (e.g. select)
• databasenames/usernames/passwords containing spaces

So please close this bug and head over to the "GDAL PostGIS Raster driver":https://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html#a4-Reportingproblems and open a new one there.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression was configured as 0

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

End of life notice: QGIS 2.18 LTR

Source:
http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/

---

• resolution was changed from to end of life
• status_id was changed from Open to Closed