User defined cast creation

From: Arun P(dot)L <arunpl(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: User defined cast creation
Date: 2013-07-05 07:34:47
Message-ID: SNT136-W30BB74E11D7105D05B940CDB7D0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi friends,

When I try to create a function which is used in user defined type cast I get the following error,

CREATE FUNCTION pg_catalog.text1(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));';
ERROR: permission denied for schema pg_catalog

I am not trying to create this function as postgres user, but as 'user1'. I need to create a user defined cast which uses this function for this particular user. I could create functions which doesn't use pg_catalog schema as same user.
What's the issue here? How can I give permission for this user1 or what's the right way to create user defined cast for a particular user?

Thanks in Advance for your help,

Arun~

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-07-05 07:40:54 Re: User defined cast creation
Previous Message giozh 2013-07-05 07:29:07 Re: unable to call a function