PostgreSQL: views flag relationship error

Here is a patch that solves the issue, it works with MySQL too, but I didn't checked if it has any affect on performance.

There are already a whole bunch of issues open about this problem:

https://www.drupal.org/project/issues/flag?text=postgresql&status=Open&p... →

In particular 🐛 SQL query error on PostgreSQL 9.5 when try to list Bookmarks Active

There's also a core issue to fix this in the core Views module: [#307953]

Please read all of those and evaluate the proposed solution and comment/contribute to those issues. Perhaps even triage them and narrow them down to a smaller number of issues so we can more effectively deal with this in one place without losing/ignoring all the other contributions that have been made to this problem.

Thanks, I reviewed issues and I see it is a duplicate of #3260731 → and #2929733 🐛 SQL query error on PostgreSQL 9.5 when try to list Bookmarks Active . They have no patches, I'll add the patch to the latest one and close another one.

Other issues as I see are related to DB field type change to int, I remember your answer on this point.

Core views issue as I see also should resolve it.