PostgreSQL problems on entity_id of type varchar with flagging and flag_count tables

This seems to be a duplicate of 🐛 SQL query error on PostgreSQL 9.5 when try to list Bookmarks Active .

I had this problem and was able to solve it with in the patch in #3079534-27: Views JOIN condition fails in PostgreSQL when comparing entity identifiers of different datatypes → .

The patch in #27 of the core issue fixed one problem but lead to this message:

Exception in Bookmarks[bookmarks]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "bookmark"

I fixed this by casting to text instead of bigint. It was trying to cast a text ID to int and that is an "invalid input syntax for type bigint". The updated patch is in #29 of the core issue.