Re: [GENERAL] Not able to change the owner of function

2010-02-24 Thread Albe Laurenz
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

[GENERAL] Not able to change the owner of function

2010-02-23 Thread Jignesh Shah
Hi, 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=#

Re: [GENERAL] Not able to change the owner of function

2010-02-23 Thread Frank Heikens
Skip the SET-keyword: ALTER FUNCTION test_create() OWNER TO masanip; Regards, Frank Op 24 feb 2010, om 07:14 heeft Jignesh Shah het volgende geschreven: Hi, 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

Re: [GENERAL] Not able to change the owner of function

2010-02-23 Thread Jignesh Shah
Thanks :) I am going crazy at times. On Wed, Feb 24, 2010 at 12:04 PM, Frank Heikens frankheik...@mac.comwrote: Skip the SET-keyword: ALTER FUNCTION test_create() OWNER TO masanip; Regards, Frank Op 24 feb 2010, om 07:14 heeft Jignesh Shah het volgende geschreven: Hi, could you