lo_open problems
I am using some large object, but lo_open always returns -1. I don't
know why.
Here is a code snipet (compiled with g++ for C++).
/*
* create the large object
*/
Oid lobjId = lo_creat(conn, INV_READ | INV_WRITE);// works
if (lobjId == 0){
fprintf(stderr, "can't create large object\n");
return 0;
}
int lobj_fd = lo_open(conn, lobjId, INV_WRITE);// == -1
if(lobj_fd < 0){
fprintf(stderr, "can't open large object (%d)\n", lobjId);
return 0;
}
lo_creat works and I can use psql with '\dl' to see the new lo created,
but lo_open returns '-1'. In what cases would lo_open fail after a
successfull lo_creat?
Running the provided sample program works, so lo support is there, but
in my large application I cannot open the lo.
any ideas?
james
James Leigh <james.leigh@ottawa.com> writes:
I am using some large object, but lo_open always returns -1. I don't
know why.
Are you doing this inside a transaction block?
regards, tom lane
Tthat was it, Thanks. I did not see that in the docs, it should be
added.
cheers,
james
Show quoted text
On Mon, 2002-03-04 at 18:10, Tom Lane wrote:
James Leigh <james.leigh@ottawa.com> writes:
I am using some large object, but lo_open always returns -1. I don't
know why.Are you doing this inside a transaction block?
regards, tom lane
James Leigh wrote:
Tthat was it, Thanks. I did not see that in the docs, it should be
added.cheers,
jamesOn Mon, 2002-03-04 at 18:10, Tom Lane wrote:
James Leigh <james.leigh@ottawa.com> writes:
I am using some large object, but lo_open always returns -1. I don't
know why.Are you doing this inside a transaction block?
I see it in the docs. It is missing somewhere else?
<note>
<para>
All large object manipulation <emphasis>must</emphasis> take
place within an SQL transaction. This requirement is strictly
enforced as of <productname>PostgreSQL 6.5</>, though it has been an
implicit requirement in previous versions, resulting in
misbehavior if ignored.
</para>
</note>
</para>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026