I get an error from Redshift (based on PostgreSQL 8), suggesting I should use SUBSTRING() instead of SUBSTR() (see attated file). Is this something I can change in my configuration, perhaps?
Intermittent error from Redshift: SUBSTR() not supported
Interesting - the original thread for Redshift support did not meantion such an incompatibility. Is that perhaps an older Redshift version?
Prefer SUBSTRING() over SUBSTR() in Postgres mode, to restore Redshift compatibility. See https://www.heidisql.com/forum.php?t=38326 and issue #1259
Please login to leave a reply, or register at first.