PostgreSQL: views flag relationship error

Problem/Motivation

Using PostgreSQL as DB backend there is the next error adding flag relationship to a view:

SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: bigint = character varying LINE 4: INNER JOIN "flagging" "flagging_taxonomy_term_field_data" ON taxonomy_term_field_data.tid = flagging_taxonomy_term_field_data.entity_id

Proposed resolution

Cast entity id to string

Remaining tasks

Didn't checked reversed case: content relationship in view based on flaggings.