splashblot / dronedb

Location Intelligence & Data Visualization tool
http://carto.com
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

👀🚨 Postgres' max-length for a table name is 63chars, adding `_raster` might go wrong #87

Closed apercas closed 6 years ago

apercas commented 6 years ago

Context

When importing a raster (tif file) we add the suffix _raster and in case the name of the file plus the suffix is longer than 63 chars postgresql won't save it properly, thus the dataset won't be treated as a raster

Steps to Reproduce

  1. Drag and drop a raster with a name 56 chars or more

Current Result

The name is shortened, no _raster added

Expected result

@ivanprado and me decided to truncate the name beforehand in case is longer than 56 chars, but we will need a better way to mark the dataset as raster

apercas commented 6 years ago

Pushed to https://github.com/splashblot/dronedb/commit/2c1ea3e546a77db5f19d2b8590a07f98f8bfa5e3