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?
Ads were blocked - no problem. But keep in mind that developing HeidiSQL,
user support and hosting takes time and money. You may want to
send a donation instead.
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?
Oh, look at issue #1259 - that replaced LEFT()
with SUBSTR()
in PostgreSQL mode, including Redshift. Looks like Redshift needs SUBSTRING()
then. The docs also state that SUBSTRING()
is a valid option on normal PostgreSQL servers, even older ones.
Code modification/commit
38c3a82
from Ansgar Becker <anse@heidisql.com>,
8 months ago,
revision 6338
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.