[HACKERS] IN FIRE

2002-09-10 Thread Stanislav Silnitski 


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)

I realy NEED a prompt advice!

Please find a couple of minutes for reply!
TIA
Stanislav

ps I run FreeBSD-4.4 + ported PostgreSQL-7.1.3
pps my other pg-connected apps run OK


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] IN FIRE

2002-09-10 Thread Mario Weilguni 

 
 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)

Use transactions (BEGIN; END;). Large objects rely on this



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster