Re: IN FIRE

Stanislav Silnitski <stalker(at)minicorp(dot)ru> writes:

> HELP!!!
>
> I'm stuck for strange reason!
> This is my first attempt to use pg_lo concept in my apps:
>
> ...
> Oid oid;
> PGconn* dbcon = PQconnectdb(conninfo.c_str());
> oid = lo_creat(dbcon, INV_WRITE | INV_READ);
> int pgfd = lo_open(dbcon, oid, INV_WRITE | INV_READ);
> ...
>
>
> lo_open ALWAYS returns -1 while oid is positive (I can even see oid
> in pg_largeobject system table)!!!!
>
> postmaster reports the following:
> ERROR: lo_lseek: invalid large obj descriptor (0)

You need to do all your LO manipulation inside a transaction. See the
docs.

-Doug