lo_<commands> and SU privs

From: Bell John <jbelllinux(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: lo_<commands> and SU privs
Date: 2001-10-15 08:02:19
Message-ID: 20011015080219.86714.qmail@web12602.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Under PostgreSQL 7.1.3 (RH Linux 7.1 platform) I get
the following whenever trying to manipulate large
objects either from psql or sql oriented API's (eg.
PoPy, psycopg, pypgsql (DPAPI kit)):

You must have Postgres superuser privilege to use
server-side lo_import. Anyone can use the client-side
lo_import provided by libpq.

Is there any way to disable this behaviour or to give
a user the priviliges that are being looked for? This
effectively cripples the vast majority of programmatic
interfaces to PostgreSQL ie. all those that are more
than wrappers around libpq.

John

__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Gasparin 2001-10-15 08:40:17 Re: VACUUM, 24/7 availability and 7.2
Previous Message xavier lhomme 2001-10-15 07:06:59 store a 3D path