Re: Client-site "lo_export"

Поиск
Список
Период
Сортировка
От Dmitriy Igrishin
Тема Re: Client-site "lo_export"
Дата
Msg-id CAAfz9KPtLJnf0GPHy=NV2a1C=8OT1FJUvFKyttSP9roUt_z69w@mail.gmail.com
обсуждение исходный текст
Ответ на Client-site "lo_export"  (whiplash <whiplash@bss.org.ua>)
Список pgsql-general
Hey,

2011/10/28 whiplash <whiplash@bss.org.ua>
Hello!

I use client-side "lo_export" for save large object to file. If i login as database owner then i do not have error (output file exists), but if i login as not database owner then function "lo_export" returning -1. My code is simple:

PGresult *res = PQexec(pg_conn, "begin");
PQclear(res);
int ret = lo_export(pg_conn, repo_oid, filename);
res = PQexec(pg_conn, "end");
PQclear(res);

OS: Win7, 32-bit
PostgreSQL: 9.1.0

What could
be the problem?

Thank you for helping!
I guess it's because of insufficient privileges on the LOB.
Please refer this URL:
http://www.postgresql.org/docs/9.1/static/lo-implementation.html


--
// Dmitriy.


В списке pgsql-general по дате отправления:

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Re: From select to delete
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: From select to delete