Postgresql error which probably means that the SQL command is wrong even for MySQL...

Has we are working on a website, we had this error in i18nblocks_locale_refresh() which is generated because whoever wrote the SQL command tries to compare the delta value (a string) with an identifier (an integer). PostgreSQL doesn't like to auto-convert data types...

The statement in question would require a CAST(), as I added here, to work with PostgreSQL:

function i18nblocks_locale_refresh() {
  $result = db_query("SELECT DISTINCT b.module, b.delta, b.title, bx.body, bx.format, i.ibid, i.language
            FROM {blocks} b
            LEFT JOIN {boxes} bx ON b.module = 'block' AND b.delta = CAST(bx.bid AS TEXT)
            LEFT JOIN {i18n_blocks} i ON b.module = i.module AND b.delta = i.delta");
  ...

However, I really think that this statement is wrong. Deltas and block identifiers have nothing to do between each others. Deltas can be strings (i.e. 'left', 'right', etc.) and not numbers and as such cannot in any way match a 'bid'.

So there is an attached temporary patch for those who have the errors and want to avoid those, but the function itself is likely to do nothing most of the time, or not exactly the right thing, at least.