From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Jignesh Shah *EXTERN*" <jignesh(dot)shah1980(at)gmail(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "postgresql novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Not able to change the owner of function |
Date: | 2010-02-24 08:51:00 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C20393819C@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2010-02-24 08:58:28 | Re: |
Previous Message | Greg Smith | 2010-02-24 08:33:12 | Re: pg_buffercache's usage count |
From | Date | Subject | |
---|---|---|---|
Next Message | A B | 2010-02-24 09:09:36 | Need help with update |
Previous Message | Michael Wood | 2010-02-24 07:57:13 | Re: Seeking experiences 'accessing' Microsoft Active Directory credentials from PostgreSQL, in conjunction with the sys admin / IT... |