From: Miguel García <rocho08@yahoo.es>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: lo_write and lo_import does not work!
Date: Wed, 18 Apr 2007 14:21:04 +0000 (GMT)
Message-ID: <20070418142104.24936.qmail@web26611.mail.ukl.yahoo.com> (raw)
It works!!
Thank you very much.
----- Mensaje original ----
De: Alvaro Herrera <alvherre@commandprompt.com>
Para: Miguel García <rocho08@yahoo.es>
CC: pgsql-interfaces@postgresql.org
Enviado: miércoles, 18 de abril, 2007 16:02:47
Asunto: Re: [INTERFACES] lo_write and lo_import does not work!
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
____________________________________________________________________________________
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rocho08@yahoo.es, alvherre@commandprompt.com
Subject: Re: lo_write and lo_import does not work!
In-Reply-To: <20070418142104.24936.qmail@web26611.mail.ukl.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox