Thread: [ psqlodbc-Bugs-1011196 ] Cannot insert very large blobs
Bugs item #1011196, was opened at 2012-05-21 21:57 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011196&group_id=1000125 Category: None Group: None Status: Open Resolution: None Priority: 3 Submitted By: Michael Vitale (pgdude) Assigned to: Nobody (None) Summary: Cannot insert very large blobs Initial Comment: I can use the PostgreSQL ODBC driver to insert a blob (bytea) of 128 megabytes, but when I try to insert one that is 399megabytes it fails with: Query buffer overflow in copy_statement_with_parameters The actuall call that fails is SQLExecute. Here is the snippet of code I see in convert.c: enlarge_query_statement(QueryBuild *qb, size_t newsize) { size_t newalsize = INIT_MIN_ALLOC; CSTR func = "enlarge_statement"; if (qb->str_size_limit > 0 && qb->str_size_limit < (int) newsize) { < here is the branch that is executed> ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011196&group_id=1000125