Postgres Pro
Downloads
Home   >   mailing lists

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

From Jignesh Shah
Subject Re: Not able to change the owner of function
Date
Msg-id c11950271002232238s3310d9fbicd50bf0597b78852@mail.gmail.com
Whole thread Raw
In response to Re: Not able to change the owner of function  (Frank Heikens <frankheikens@mac.com>)
List pgsql-general
Tree view
Thanks :) I am going crazy at times.

On Wed, Feb 24, 2010 at 12:04 PM, Frank Heikens <frankheikens@mac.com> 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 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=#
 
Thanks in advance,
Jack





pgsql-general by date:

Previous
From: Frank Heikens
Date:
Subject: Re: Not able to change the owner of function
Next
From: John Gage
Date:
Subject: Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column