Skip site navigation (1) Skip section navigation (2)

BUG #4674: Unable to open lob

From: "Yuichi Tanaka" <yuichi_tanaka(at)cybozu(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4674: Unable to open lob
Date: 2009-02-24 07:27:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4674
Logged by:          Yuichi Tanaka
Email address:      yuichi_tanaka(at)cybozu(dot)co(dot)jp
PostgreSQL version: 8.3.6
Operating system:   Linux
Description:        Unable to open lob

I wrote the code like below:

    // open lob
    if( (pgsql_lofd1 = lo_open(pgsql, oid, pgsql_mode)) == -1 ) {
        printf("error: first lo_open\n");

    // send query asynchronously
    PQsendQuery(pgsql, "INSERT INTO bar (name) VALUES ('aaa');" );

    // open lob
    if( (pgsql_lofd2 = lo_open(pgsql, oid+1, pgsql_mode)) == -1 ) {
        printf("error: second lo_open\n");

This program displays "error: second lo_open".
Is this a bug or correct behavior?


pgsql-bugs by date

Next:From: kos41Date: 2009-02-24 10:09:14
Subject: BUG #4675: FATAL: could not reattach to shared memory
Previous:From: tomasDate: 2009-02-23 14:28:32
Subject: Re: Link to MS Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group