Re: [ADMIN] Issue in save and retreive file in postgres

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: [ADMIN] Issue in save and retreive file in postgres
Дата
Msg-id 4FE5A498.5040105@ringerc.id.au
обсуждение исходный текст
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Robert Poor
Дата:
Сообщение: configuring queries for concurrent updates
Следующее
От: Joe Van Dyk
Дата:
Сообщение: row_to_json question