Case: 00632715, 00632678, 00634759

I just installed ADS 19.0 from 18.0 and am now unable to browse or do 
anything related to functions (schema compare/sync, function alter, edit 
etc ) which worked in v18 

I'm using Postgres 9.6.6 on RDS. 

Please note that RDS does not allow access to the catalog vew "pg_authid" 
so I can not grant permission to that table under AWS RDS, as explained 
here but there may be an alternative for your developers to use "pg_roles" 
instead: 
"The default user created with the instance is not a real sysadmin(even a 
user with rds_admin) and i actually admire why AWS didn't treat the 
rds_admin user like a typical sysadmin. The pg_authid view has the user 
credentials exposed and thats a potential security risk, as a result good 
AWS folks have taken a conscious decision to disallow the user with 
rds_admin to get to the mentioned view. That said, the rds_admin user can 
read the pg_roles view which is similar to pg_authid but with out the 
credentials exposed. " 

sample SQL that errors: 

SELECT 
p.relname, 
pn.nspname, 
u.rolname AS table_owner, 
td.description AS table_description 
FROM 
pg_catalog.pg_class c 
LEFT JOIN pg_catalog.pg_inherits i 
ON i.inhrelid = c.oid 
LEFT JOIN pg_catalog.pg_class p 
ON i.inhparent = p.oid 
LEFT JOIN pg_catalog.pg_namespace cn 
ON cn.oid = c.relnamespace 
LEFT JOIN pg_catalog.pg_namespace pn 
ON pn.oid = p.relnamespace 
LEFT JOIN pg_catalog.pg_roles u 
ON c.relowner = u.oid 
LEFT JOIN pg_catalog.pg_description td 
ON c.oid = td.objoid AND 
td.objsubid = 0 
WHERE 
c.relname = 'account_emails' AND 
cn.nspname = 'accounts' 

SUPPORT INFO: 

License Key: 
11564BC8D2B2FCD07B71DCFD8C81BECA22C4335C8282831F**************** 

Product: Aqua Data Studio 
Version: 19.0.0 
Build #: 55797 
Build Date: 2018-Apr-24 08:26:49 AM 

Operating Environment: Mac OS X (10.13.4, x86_64) / UTF-8 / en / US / 
Oracle Corporation 1.8.0_40-b27 
Memory: Max=704,643,072; Total=345,505,792; Free=171,063,008; CPUs=8 

In-Window Graphics Capabilities 
Graphics Vendor: Intel Inc. 
OpenGL Renderer: Intel Iris Pro OpenGL Engine 
OpenGL Version: 2.1 INTEL-10.32.48 
Double-Buffering: Enabled 
Anti-Aliasing: Enabled 
Anti-Aliasing Sample Count: 8 
Hardware Acceleration: Enabled 
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8 
Depth Bits: 16 
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0 
Initialization Time: 1781 ms 


Offscreen Graphics Capabilities 
Graphics Vendor: Brian Paul 
OpenGL Renderer: Mesa OffScreen 
OpenGL Version: 2.1 Mesa 7.8.2 
Double-Buffering: Disabled 
Anti-Aliasing: Disabled 
Anti-Aliasing Sample Count: 0 
Hardware Acceleration: Disabled 
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8 
Depth Bits: 16 
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16 
Initialization Time: 55 ms 
Hardware PBuffer Available: No 
Using PBuffer: No 
Using Ram Buffer: Yes 
Offscreen Rendering: Enabled 
Offscreen Buffer Size: 800x600