From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Craig James <cjames@emolecules.com>
To: Alanoly Andrews <alanolya@invera.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Date: Wed, 03 Sep 2014 09:33:05 -0700
Message-ID: <540742C1.50106@aklaver.com> (raw)
In-Reply-To: <CAFwQ8rd0Abfm=0j4Oq5D0hcRPBn=D7A-HJzSPJmDk=EgDMA9zQ@mail.gmail.com>
References: <6909b219ecae4d41b431efdaf6c953a3@Exch2.invera.com>
<CAFwQ8rd0Abfm=0j4Oq5D0hcRPBn=D7A-HJzSPJmDk=EgDMA9zQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
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-admin@postgresql.org
Cc: adrian.klaver@aklaver.com, cjames@emolecules.com, alanolya@invera.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
In-Reply-To: <540742C1.50106@aklaver.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