Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.
От | Adrian Klaver |
---|---|
Тема | Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization. |
Дата | |
Msg-id | 540A3480.9040601@aklaver.com обсуждение исходный текст |
Ответ на | Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization. (Alanoly Andrews <alanolya@invera.com>) |
Список | pgsql-general |
On 09/05/2014 08:33 AM, Alanoly Andrews wrote: > Hi Adrian, > > 1. We are storing our large objects in a table column whose datatype is "lo" (which, I understand, ultimately is in fact"bytea"). As way of testing where the issue is, you might explore saving some images in a test table directly to a bytea column. This is presumably what the Bytea as LO option is for. Then run CLUSTER on the test table and see what happens. > 2. The error messge returned to the VB is, yes, very generic. And the backend postgres server does not have any messagesrelevant to this issue. > 3. We set the trace on in the odbc driver and got a large log file, from which I give below the part that I think is significant.It refers to the "buffer size being too small". Where, in the odc settings, do we set the buffer size? > I would recommend posting the below(with some background information) on the -odbc list where there are folks that might better understand it. > > STELimageViewOn 834-fec EXIT SQLGetData with return code 1 (SQL_SUCCESS_WITH_INFO) > HSTMT 0x002BFC70 > UWORD 2 > SWORD 1 <SQL_C_CHAR> > PTR 0x0018EECF [ 0] "" > SQLLEN 0 > SQLLEN * 0x0018EEA4 (6) > > DIAG [01004] The buffer was too small for the GetData. (-2) > > STELimageViewOn 834-fec ENTER SQLGetData > HSTMT 0x002BFC70 > UWORD 2 > SWORD -2 <SQL_C_BINARY> > PTR <unknown type> > SQLLEN 0 > SQLLEN * 0x0018EE54 > > STELimageViewOn 834-fec EXIT SQLGetData with return code 1 (SQL_SUCCESS_WITH_INFO) > HSTMT 0x002BFC70 > UWORD 2 > SWORD -2 <SQL_C_BINARY> > PTR <unknown type> > SQLLEN 0 > SQLLEN * 0x0018EE54 (46165) > > DIAG [01004] The buffer was too small for the GetData. (-2) > > STELimageViewOn 834-fec ENTER SQLGetData > HSTMT 0x002BFC70 > UWORD 2 > SWORD -2 <SQL_C_BINARY> > PTR <unknown type> > SQLLEN 32768 > SQLLEN * 0x003CE284 > > STELimageViewOn 834-fec EXIT SQLGetData with return code -1 (SQL_ERROR) > HSTMT 0x002BFC70 > UWORD 2 > SWORD -2 <SQL_C_BINARY> > PTR <unknown type> > SQLLEN 32768 > SQLLEN * 0x003CE284 > > DIAG [S1000] Error reading from large object. (1) -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления:
Предыдущее
От: Cal HeldenbrandДата:
Сообщение: Re: Querying a time range across multiple partitions
Следующее
От: David G JohnstonДата:
Сообщение: Re: Querying a time range across multiple partitions