Re: Not able to change the owner of function - Mailing list pgsql-general

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