Re: User defined cast creation

Hello

2013/7/5 Arun P.L <arunpl(at)hotmail(dot)com>:
> 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?
>

only user with superuser rights can create object in pg_catalog schema.

Regards

Pavel Stehule

>
> Thanks in Advance for your help,
>
> Arun~