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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
