On Wed, Sep 3, 2014 at 8:13 AM, Alanoly Andrews <alano...@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. Craig > *The database is on an AIX server (version 6.1). **Postgres version is > 9.1.4. * > > *I**’**d welcome **any** input towards the resolution of this problem. * > > *Thanks.* > > *Alanoly Andrews* > *alano...@invera.com <alano...@invera.com>* > > > * ________________________________ * > If you no longer wish to receive any of our emails, click on > *UNSUBSCRIBE.* <unsubscr...@invera.com?subject=***Unsubscribe***> This > e-mail may be privileged and/or confidential, and the sender does not waive > any related rights and obligations. Any distribution, use or copying of > this e-mail or the information it contains by other than an intended > recipient is unauthorized. If you received this e-mail in error, please > advise me (by return e-mail or otherwise) immediately. > > > Si vous ne désirez plus recevoir de nos courriels, veuillez appuyer sur > *DÉSABONNEMENT.* <unsubscr...@invera.com?subject=***Unsubscribe***> Ce > courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux > droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou > copie de ce message ou des renseignements qu'il contient par une personne > autre que le (les) destinataire(s) désigné(s) est interdite. Si vous > recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par > retour de courriel ou par un autre moyen. > -- --------------------------------- Craig A. James Chief Technology Officer eMolecules, Inc. ---------------------------------
