Intermittent error from Redshift: SUBSTR() not supported

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?

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.

As I understand it, Redshift is based on PostgreSQL 8, and the manual for that version doesn't mention SUBSTR(), only SUBSTRING().

Not sure about the version - it was created a couple of months ago, but you don't get a choice of versions.

Next HeidiSQL build uses SUBSTRING for all PG servers including Redshift.

You can update to that new build in half an hour via Help > Check for updates.

Thanks! That was bloody quick, if you'll excuse my language :-)