On Thu, Sep 18, 2003 at 10:54:49AM +0100, Oliver Elphick wrote: > > > I want to add some function to postgres database from > > postgresql-contrib package (some encryption functions). Packages install > > normally, but when I'm trying to add functions to database it complains: > > > > [lex.lexa]$ psql mf </usr/lib/postgresql/contrib/pgcrypto.sql > > SET > > SET > > ERROR: c: permission denied > > ERROR: c: permission denied > > You will find it easier to understand what is happening if you use the > -e option to psql, which will show you the queries that are being > executed. This is the start of the sql script: > > -- Adjust this setting to control where the objects get created. > SET search_path = public; [SKIP]
> I think that your problem is that you (the current postgresql user) does > not have permission to create a C language function. Such a function > would have complete access to any database structures and could be used > to bypass access security, so you should probably be running as postgres > superuser to do this successfully. > Thank you very much. Indeed I've ran this script as ordinary user, no as postgres user. That was a problem, now everything works ok. Thanks. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
