Re: Not able to change the owner of function

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: Frank Heikens <frankheikens(at)mac(dot)com>
Cc: 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 06:38:32
Message-ID: c11950271002232238s3310d9fbicd50bf0597b78852@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Thanks :) I am going crazy at times.

On Wed, Feb 24, 2010 at 12:04 PM, Frank Heikens <frankheikens(at)mac(dot)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
>
>
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-02-24 06:51:54 Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column
Previous Message Frank Heikens 2010-02-24 06:34:34 Re: Not able to change the owner of function

Browse pgsql-novice by date

  From Date Subject
Next 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...
Previous Message Frank Heikens 2010-02-24 06:34:34 Re: Not able to change the owner of function