From: David G Johnston <david.g.johnston@gmail.com>
To: pgsql-general@postgresql.org
Subject: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Date: Thu, 4 Sep 2014 07:15:47 -0700 (PDT)
Message-ID: <1409840147898-5817761.post@n5.nabble.com> (raw)
In-Reply-To: <54086B77.9090102@aklaver.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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Adrian Klaver-4 wrote
> On 09/04/2014 05:56 AM, Alanoly Andrews wrote:
>> Hi Adrian,
>>
>> Thanks for that explanation of how the "relfilenode" changes after a
>> table reorganization. It is not surprising that this happens because the
>> table rows are being physically moved from one location to another. But
>> such changes at the backend should be transparent to the end user. The VB
>> code at the client side runs a simple sql like "select image from
>> image_table where image_key=somevalue". There is no reference to
>> postgres-specific internal variables like "oid" and "relfilenode". I do
>> not know the inner workings of the postgres odbc driver; but I would be
>> surprised if it works at the granularity of "oid" and "relfilenode" and
>> that it would store the actual physical values of relfilenode (which
>> would keep changing after every table reload, reorg etc.).
>
> In addition to what David mentioned, some more detail on what you are
> calling a 'large object'. In Postgres there is not really a 'large
> object' type(though I am guilty of saying there is), instead there is a
> way of working with large objects outside of the bytea type. Now in the
> ODBC FAQ there is a recipe for creating a 'lo' type:
>
> http://psqlodbc.projects.pgfoundry.org/faq.html#4.4
>
> Is this what you are using?
>
> If not how are you working with the large objects?
>
> Also given that you are working with the Postgres ODBC driver, you might
> want to break the cross post rule and ask this question on the psql-odbc
> list:
>
> http://www.postgresql.org/list/pgsql-odbc/
>
> In any case your ODBC settings would be helpful.
I suspect the OP is referring to the contrib module/extension:
http://www.postgresql.org/docs/9.1/interactive/lo.html
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Cannot-retrieve-images-inserted-through-VB-and-odbc-after-a-...
Sent from the PostgreSQL - general mailing list archive at Nabble.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: david.g.johnston@gmail.com, pgsql-general@postgresql.org
Subject: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.
In-Reply-To: <1409840147898-5817761.post@n5.nabble.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