I've got a function, that simply does an insert into a table. If I grant the execute right to a db-user that has no insert right on the target table, the execution of the function by that user fails with 'ERROR permission denied'.
I know that on ORACLE you can grant execute on a function to an user that has no insert rights on a table - but can write to it through the function.
Is this a postgres(7.3.2)-problem? Or have a made mistake somewhere? Is there perhaps a workaround? Is this yet unimplemented?