Must be superuser to run disable_duplicate_key_error
This method works well we run it from the dbadmin. However, when we try to run it from another user we get an error.
We also tried to grant permission but then we get another error that the function doesn't exist.
dbadmin=> GRANT EXECUTE ON FUNCTION DISABLE_DUPLICATE_KEY_ERROR() to athena_ui;
ROLLBACK 2059: Function with specified name and parameters does not exist: DISABLE_DUPLICATE_KEY_ERROR
We want to execute this function from another user (athena_ui), is it possible?