3653920 - Owner change ignored during reverse engineering of PostgreSQL functions - SAP PD

• A SQL script is reversed to create a function and then change the owner of this function.
• The ALTER FUNCTION command and the OWNER TO clause are ignored.
• The new owner is not applied.
• Example:
  

  CREATE OR REPLACE FUNCTION USER1.FUNCTION1 (arg1 text)
  RETURNS INTEGER
  LANGUAGE plpgsql
  AS $$
  BEGIN
      RETURN arg1;
  END;
  $$;

  ALTER FUNCTION USER1.FUNCTION1 (arg1 text) OWNER TO USER2
  ;

• SAP PowerDesigner (PD) 16.7
• PostgreSQL

PowerDesigner, reverse, RE, sql, psql, PostgreSQL, owner, user, CR831206, CR#831206, 831206 , KBA , BC-SYB-PD , PowerDesigner , Known Error