| From: | Nelson Gonzaga <ngonzaga(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Grant on lo_export() |
| Date: | 2018-08-01 11:12:41 |
| Message-ID: | 1160328940.343057.1533121961953@mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all,I'm trying to use lo_import / lo_export and apparently I have permission denied:
command:select lo_export(oid_imagem, '/tmp2/erro_export1.png') fromimagem where nome_imagem = 'erro';
ERROR: mustbe superuser to use server-side lo_export()SQL state:42501Hint:Anyone can use the client-side lo_export() provided by libpq.
It's okay when I enter the data as superuser like this:insert into image (image_name, oid_picture) values ('error1', lo_import ('/ tmp2 / erro.png'));
and the table:create table image (image_name varchar (20), oid_image oid);
I Use Linux Debian 7 and Postgresql 9.4
Any idea?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-08-01 14:06:06 | Re: Grant on lo_export() |
| Previous Message | Amit Langote | 2018-07-31 01:11:51 | Re: Fwd: Problem with a "complex" upsert |