[postgis-tickets] [PostGIS] #3147: [raster] raster2pgsql should check that the resulting table name it's a valid SQL name.

[PostGIS]

#3147: [raster] raster2pgsql should check that the resulting table name it's a
valid SQL name.
--------------------------+---------------------------
 Reporter:  tinproject    |      Owner:  dustymugs
     Type:  defect        |     Status:  new
 Priority:  low           |  Milestone:  PostGIS 2.1.8
Component:  raster        |    Version:  2.1.x
 Keywords:  raster2pgsql  |
--------------------------+---------------------------
 For example, executing:

 raster2pgsql 0457h30.tif | psql -d "db" -h "host" -U "user" -W

 ends with a table named 0457h30 on the database. That name it's not a
 valid PostgreSQL table name so a "SELECT * FROM 0457h30;" will fail, also
 a "DROP TABLE 0457h30;" fails too.

 Tested with raster2pgsql RELEASE: 2.1.7 GDAL_VERSION=111 (r13414) on
 Windows.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3147>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.