[NOVICE] array_agg cast issue

Hi,

We moved our development database from Windows (PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit to) to Linux (PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit). When using pgAdmin 4 (v1.4) and DataGrip I get an occasional error message as I’m clicking on table names.

For example

  ERROR: function array_agg(bigint) is not unique

    Hint: Could not choose a best candidate function. You might need to add explicit type casts.

    Position: 255.

   (439ms)

For example, when I’m in pgAdmin and I click on a view with the “SQL” tab on I get

  ERROR: function array_agg(text) is not unique
  LINE 16: array_agg(provider || '=' || label)
  ^
  HINT: Could not choose a best candidate function. You might need to add explicit type casts.

I also get a similar issue with this query which seems to work fine on other databases created freshly on 9.6.1.

  select array_agg(1::bigint);

The obvious thing to do is to create a cast – how do I do that? Has there been a change in the default casts from 9.0 to 9.6.1?

Peter