Message-ID: <540742C1.50106@aklaver.com>
Date: Wed, 03 Sep 2014 09:33:05 -0700
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: Craig James <cjames@emolecules.com>, Alanoly Andrews <alanolya@invera.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
 "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Re: Cannot retrieve images inserted through
 VB and odbc, after a table reorganization.
References: <6909b219ecae4d41b431efdaf6c953a3@Exch2.invera.com>
 <CAFwQ8rd0Abfm=0j4Oq5D0hcRPBn=D7A-HJzSPJmDk=EgDMA9zQ@mail.gmail.com>
In-Reply-To: 
 <CAFwQ8rd0Abfm=0j4Oq5D0hcRPBn=D7A-HJzSPJmDk=EgDMA9zQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 09/03/2014 09:12 AM, Craig James wrote:
>
> On Wed, Sep 3, 2014 at 8:13 AM, Alanoly Andrews <alanolya@invera.com
> <mailto:alanolya@invera.com>> wrote:
>
>     *We have an issue with images (**TIFF files) that are loaded into a
>     postgres database table (where the image field is defined as type
>     **“**lo**”**)**. The code to load the images is written in VB and
>     the connection to the database is through postgres odbc**installed
>     on the PC. ****All images inserted through the VB program are
>     retrievable also through odbc/VB, as long as the table **rows **at
>     the backend **are**not re**organized in any way. If the table
>     dat**a**is unloaded/reloaded or clustered (on an index) or
>     rel**oaded through a pg_dump and restore, then **on trying to
>     retrieve the images, **the VB program gets the error :
>     **“**Multiple-step OLE DB operation generat**ed errors. Check each
>     OLE DB status value**……**etc**”**.*
>     *The data in the backend database is still readable through other
>     image retrieval progr**ams connecting directly to the server (not
>     through ODBC or VB).*
>
>
> Are you reloading into the very same database, or into a different one?
> Your question doesn't make it clear. If you're loading into a new
> database, then one thing that comes to mind is that the bytea_output
> parameter in postgresql.conf might be different on the second database.

The OP is using the lo type, so I suspect it is something to do with the 
OIDs changing. I do not use lo so I cannot really be more helpful.

>
> Craig


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin