From: Craig Ringer <ringerc@ringerc.id.au>
To: Vishwas Dwivedi <vishwas.sd@gmail.com>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: [ADMIN] Issue in save and retreive file in postgres
Date: Sat, 23 Jun 2012 19:12:24 +0800
Message-ID: <4FE5A498.5040105@ringerc.id.au> (raw)
In-Reply-To: <CA+UJrGaMH273oq4wsS45rXQaPzFKpUXAaFfxKiLRLy6ei1i1oA@mail.gmail.com>
References: <CA+UJrGYaKH4Nj07LMFyxDxEKK5B+ZNuxu2p1RZH8Ft0spJ+v9Q@mail.gmail.com>
<4FE1E0AD.80405@ringerc.id.au>
<CA+UJrGaMH273oq4wsS45rXQaPzFKpUXAaFfxKiLRLy6ei1i1oA@mail.gmail.com>
On 06/23/2012 02:48 PM, Vishwas Dwivedi wrote:
> I am using postgreSQL 9.1.
>
> My problem is when I retrieve pdf file data from postgreSQL and create
> a pdf
> file in temp folder of my application.
>
> The file gets created but not able to open it, shows some error.
> One more thing that in my code I am converting byte array to file
> stream when saving and retrieving file from database.
>
> both time save and retrieve, the byte array size differs. I don't know
> why?
Please reply to the list, not to me. Unfortunately the list doesn't set
reply-to.
Please provide the FULL EXACT TEXT OF THE ERROR MESSAGE by copying and
pasting it into an email.
See: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
As for byte array differences, which client library are you using? Is it
possible it's outdated and doesn't understand bytea_format=hex ? See
http://www.postgresql.org/docs/9.1/static/datatype-binary.html .
--
Craig Ringer
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: ringerc@ringerc.id.au, vishwas.sd@gmail.com, pgsql-general@postgresql.org
Subject: Re: [ADMIN] Issue in save and retreive file in postgres
In-Reply-To: <4FE5A498.5040105@ringerc.id.au>
* 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