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') from imagem where nome_imagem = 'erro';
ERROR: must be superuser to use server-side lo_export()
SQL state: 42501
Hint: 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?