PG11 changes pg_proc.proisagg to prokind to support stored procedures and
authorRobert Treat <rob@xzilla.net>
Fri, 19 Jul 2019 20:40:03 +0000 (16:40 -0400)
committerRobert Treat <rob@xzilla.net>
Fri, 19 Jul 2019 20:40:03 +0000 (16:40 -0400)
commite3e8087bfd8f1fb93564b7a691f8ac9ed7c63a02
tree23350d8be1b06adefb3b2a655e859be9898c8b21
parentc7521813b599630d67e5368dd79e79cb297ee23c
PG11 changes pg_proc.proisagg to prokind to support stored procedures and
window functions, breaking functions, aggregates, and object look-up within
PPA. This commit fixes all three of these areas. In theory we should probably
add some display bits to help users differentiate between these different
types in the UI, but this at least makes the system work again.

Thanks to @decodeJarvis who initially reported the problem and provided a
proposed fix (see PR#24 on the xzilla repo). Since we needed a more
comprehensive fix, I didn't use the code, but his patch was useful for getting
started.
classes/database/Postgres.php
classes/database/Postgres10.php