Hello 2013/7/5 Arun P.L <aru...@hotmail.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~ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
