From: c k <shreeseva.learning@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] different results for large objects
Date: Tue, 17 Mar 2009 18:57:35 +0530
Message-ID: <d8e7a1e30903170627o35bae6bbrc43d5bb4865c2d45@mail.gmail.com> (raw)
In-Reply-To: <6995.1237293785@sss.pgh.pa.us>
References: <d8e7a1e30903170456q767429dt4170f19662fbd2c9@mail.gmail.com>
<6995.1237293785@sss.pgh.pa.us>
Yes, the problem is with PGAdmin and ODBC connection to MS access.
The function (given is first mail) is giving same results i.e. only IDs not
the actual data from PGAdmin and ODBC.
But for following query PGAdmin gives again only IDs, but MS Access through
ODBC gives the actual binary data.
select docimages.* from docimages where docimages.accobjecttype=9 ORDER BY
docimages.docimagename;
So I think ODBc is making some magic here for showing large object data. If
this is correct how can I retrieve the actual binary data from a
function/single statement as above?
Thanks,
CPK
On Tue, Mar 17, 2009 at 6:13 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> c k <shreeseva.learning@gmail.com> writes:
> > I am getting correct results with following query i.e. binary objects as
> > they are inserted.
>
> > select docimages.* from docimages where docimages.accobjecttype=9 ORDER
> BY
> > docimages.docimagename;
>
> > but when I created a function as follows, binary objects are not shown,
>
> There is no server-side behavior that would cause that query to show you
> a large object's contents instead of its identifying number. I suppose
> that you have some client-side code that does something magic when it
> sees a result column of type "lo", and that for some reason this code
> is not successfully recognizing the case where the column is coming out
> of a function. Since you've shown us neither the troublesome query
> nor the client-side code, it's hard to speculate further than that.
>
> regards, tom lane
>
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: shreeseva.learning@gmail.com, tgl@sss.pgh.pa.us, pgsql-general@postgresql.org
Subject: Re: [GENERAL] different results for large objects
In-Reply-To: <d8e7a1e30903170627o35bae6bbrc43d5bb4865c2d45@mail.gmail.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