Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

Next:From: Michael WoodDate: 2010-02-24 07:57:13
Subject: Re: Seeking experiences 'accessing' Microsoft Active Directory credentials from PostgreSQL, in conjunction with the sys admin / IT...
Previous:From: Frank HeikensDate: 2010-02-24 06:34:34
Subject: Re: Not able to change the owner of function

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group