Home > mailing lists

Re: Client-site "lo_export" - Mailing list pgsql-general

From	Dmitriy Igrishin
Subject	Re: Client-site "lo_export"
Date	October 28, 2011 20:00:42
Msg-id	CAAfz9KPtLJnf0GPHy=NV2a1C=8OT1FJUvFKyttSP9roUt_z69w@mail.gmail.com Whole thread Raw
In response to	Client-site "lo_export" (whiplash <whiplash@bss.org.ua>)
List	pgsql-general

Tree view

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 by date:

From: Alexander Farber
Date: 28 October 2011, 17:55:17
Subject: Re: From select to delete

From: Alexander Farber
Date: 28 October 2011, 20:38:21
Subject: Re: From select to delete

Re: Client-site "lo_export" - Mailing list pgsql-general

Previous

Next