Jignesh Shah wrote:
> could you tell me what could be the issue in below command. I
> could see that there is an option for changing OWNER of
> function but not sure why it is giving this error.
>
> techdb=# ALTER FUNCTION test_create() SET OWNER TO masanip;
> ERROR: unrecognized configuration parameter "owner"
> techdb=#
Just use the correct syntax as documented:
ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
OWNER TO new_owner
i.e., without the SET.
Yours,
Laurenz Albe