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

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 wrote: > 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

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

[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=# T