From: | Michael Vitale <michaelv(at)arin(dot)net> |
---|---|
To: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: cannot copy very large bytea data |
Date: | 2012-05-24 14:55:01 |
Message-ID: | BA84E17931D09D4FB885850262DD600531896AFA@CHAXCH02.corp.arin.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Hiroshi,
Thanks for replying back so fast.
I have checked the "bytea as LO" checkbox on the second page of the datasource in odbc adminstrator. So are you talking about a setting somewhere else or that one? If that one, then I still get this error with it checked.
I don't see any comments by you on the ticket itself at:
http://pgfoundry.org/tracker/index.php?func=detail&aid=1011196&group_id=1000125&atid=538
Respectfully Yours,
Michael Vitale
Arin DBA
American Registry for Internet Numbers
michaelv(at)arin(dot)net
________________________________________
From: pgsql-odbc-owner(at)postgresql(dot)org [pgsql-odbc-owner(at)postgresql(dot)org] on behalf of Hiroshi Inoue [inoue(at)tpf(dot)co(dot)jp]
Sent: Tuesday, May 22, 2012 11:53 PM
To: Michael Vitale
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] cannot copy very large bytea data
Hi Michael,
(2012/05/22 22:57), Michael Vitale wrote:
> I am able to copy a row with a 127megabyte column, but not with one that
> is 399 megabytes.
Please try the type lo instead of bytea.
regards,
Hiroshi Inoue
> Here is the log output of the one that fails:
>
> [4272-42.487]SQL_VARBINARY: about to call convert_to_pgbinary, used =
> 399966009
> [4272-42.488]STATEMENT ERROR: func=enlarge_statement, desc='', errnum=1,
> errmsg='Query buffer allocate error in copy_statement_with_parameters'
> [4272-42.496]CONN ERROR: func=enlarge_statement, desc='', errnum=0,
> errmsg='(NULL)'
> [4272-42.499]retval=-1
> [4272-42.500][[SQLGetDiagFieldW]] Handle=(3,08F47DD0) Rec=1 Id=4
> info=(09BF6788,12)
> [4272-42.500]PGAPI_GetDiagField entering
> rec=1[4272-42.500]ER_ReturnError: status = 1, msg = #Query buffer
> allocate error in copy_statement_with_parameters#
> [4272-42.501] szSqlState = 'HY000',len=61, szError='(null)'
> [4272-42.501]PGAPI_GetDiagField exiting 0
>
--
Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
From | Date | Subject | |
---|---|---|---|
Next Message | julia.jacobson | 2012-05-27 13:06:37 | unixODBC fails to open psqlodbcw.so library on Mac OS X 10.4 |
Previous Message | Adrian Klaver | 2012-05-23 14:18:17 | Re: Configure script unable to find PgSQL dir |