Re: postgesql-7.3.3 lo_create/lo_open fails - Mailing list pgsql-general

From Tom Lane
Subject Re: postgesql-7.3.3 lo_create/lo_open fails
Date
Msg-id 5742.1060442890@sss.pgh.pa.us
Whole thread Raw
In response to postgesql-7.3.3 lo_create/lo_open fails  (Colm Dobbs <Colm.Dobbs@aepona.com>)
List pgsql-general
Colm Dobbs <Colm.Dobbs@aepona.com> writes:

>     Oid lobjId = lo_creat(conn, INV_READ|INV_WRITE);
>     if (lobjId != -1)

This coding is wrong --- lo_creat would return 0 (InvalidOid) on
failure, not -1.  As for *why* it's failing, PQerrorMessage might
offer some hint.  I'm a tad surprised by that myself; never heard
of it happening with a connection not already in an error state.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Temporary table
Next
From: Andre Truter
Date:
Subject: File output functions in PL/pgSQL?