Re: How to convert ByteA to Large Objects

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: How to convert ByteA to Large Objects
Дата
Msg-id CAF-3MvOnpdBfdMYWe85Tx0icCzpRM5nQfWyyy-trYsa=n4H=Kw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to convert ByteA to Large Objects  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
Список pgsql-general
Caused by: org.postgresql.util.PSQLException: ERROR: column "docdta" is of type bytea but expression is of type oid
  Hint: You will need to rewrite or cast the expression."
 
Looks like that table has a column of type BYTEA, while the code expects it to be a LOB. Perhaps the easiest fix is to change the table to store a LOB instead?
One of the benefits of doing that is that you can "stream" LOB's (you access it like a file; opening, reading, seeking), whereas AFAIK you have to retrieve BYTEA data as a whole before you can start sending it to the client.

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

Предыдущее
От: Harald Fuchs
Дата:
Сообщение: Re: PostgreSQL 9.1.0 bug?
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Problem with the 9.1 one-click installer Windows7 64bit