From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Alanoly Andrews <alanolya@invera.com>
To: Craig James <cjames@emolecules.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Date: Thu, 04 Sep 2014 13:42:58 -0700
Message-ID: <5408CED2.10302@aklaver.com> (raw)
In-Reply-To: <af0397c0ba2f4fefb79c0ba63a5ab50d@Exch2.invera.com>
References: <6909b219ecae4d41b431efdaf6c953a3@Exch2.invera.com>
<CAFwQ8rd0Abfm=0j4Oq5D0hcRPBn=D7A-HJzSPJmDk=EgDMA9zQ@mail.gmail.com>
<a45db4656040438eaf2034a8f5870b8d@Exch2.invera.com>
<5407679B.2030906@aklaver.com>
<aafcb3551e2c4dddb696ec4a6d6087e8@Exch2.invera.com>
<54086B77.9090102@aklaver.com>
<af0397c0ba2f4fefb79c0ba63a5ab50d@Exch2.invera.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On 09/04/2014 08:03 AM, Alanoly Andrews wrote:
> Thanks, Adrian for the response.
>
> Yes, we are using the "large object" as per the specifications in the
> special "lo" module that we installed on the backend server. The table
> is created using the "lo" datatype for the image field and the table is
> being regularly used for insertions and retrievals using utilities other
> than ones using odbc. The odbc connection, too, works well on the table,
> as long as the table data is not reorganized after insertion(s).
>
> Here are three pages of our postgres odbc driver settings. Sorry, they
> are screen captures, not plain text!
Hmm, to me at least nothing seems out of place. Though to be honest I am
not sure what 'Bytea as LO' does in this situation.
Are you actually trying to store any large objects in bytea columns?
I searched on the error message you originally posted, but is fairly
generic and covers a lot of different error sources.
So, is there any more specific error information in either the Postgres
or ODBC logs?
>
> Alanoly.
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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, alanolya@invera.com, cjames@emolecules.com, pgsql-general@postgresql.org
Subject: Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.
In-Reply-To: <5408CED2.10302@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