Date: Wed, 18 Apr 2007 10:02:47 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Miguel =?iso-8859-1?Q?Garc=EDa?= <rocho08@yahoo.es>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: lo_write and lo_import does not work!
Message-ID: <20070418140247.GA7356@alvh.no-ip.org>
Mail-Followup-To: Miguel =?iso-8859-1?Q?Garc=EDa?= <rocho08@yahoo.es>,
	pgsql-interfaces@postgresql.org
References: <471146.38834.qm@web26607.mail.ukl.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <471146.38834.qm@web26607.mail.ukl.yahoo.com>
User-Agent: Mutt/1.5.13 (2006-08-11)

Miguel García escribió:
> Hello,
> 
> I have a little trouble using large objects with libpq an postgresql
> 8.2 in windows xp professional SP2.
> 
> I want to save and load large objects from/to database, but its fails.
> 
> If i try to use the lo_import() function
> 
> #define FILE_IN "d:/question-icon.png"
> Oid file_oid = lo_import (conn, FILE_IN);
> 
> file_oid always have 0 value, nevertheless the large object has been created in table
> pg_largeobject, but has no data.

I think your problem is that you are not running the commands inside a
transaction.  Large object IDs are closed at the end of the transaction
block, which is right after the lo_open unless you're calling BEGIN
first (or are not in autocommit mode, which is the default).

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support