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