User defined cast creation

Поиск
Список
Период
Сортировка
От Arun P.L
Тема User defined cast creation
Дата
Msg-id SNT136-W30BB74E11D7105D05B940CDB7D0@phx.gbl
обсуждение исходный текст
Ответы Re: User defined cast creation  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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~

В списке pgsql-general по дате отправления:

Предыдущее
От: giozh
Дата:
Сообщение: Re: unable to call a function
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: User defined cast creation