hdus / pg_raster_upload

QGIS plugin for uploading raster data to a PostGIS database.
GNU General Public License v2.0
5 stars 3 forks source link

Ensure table name length limit #16

Closed effjot closed 1 year ago

effjot commented 1 year ago

Except if configured differently at compile time, PostgreSQL allows a maximum length for names of tables, indexes, sequences etc. of 63 characters. This PR limits the table name length to this maximum minus the characters needed for the GiST index suffix.

Also, any question marks in the laundered table name (added by the conversion to ASCII for umlauts etc.) are replaced by underscore, which seems safer.

hdus commented 1 year ago

Your PR is merged, thank's a lot for your contribution.