I'm using Postgres 8.1 and latest ODBC driver in Windows XP with 256 MB RAM.
When trying to insert a 6 MB binary file to a bytea field, out-of-memory
error is writeen to ODBC log file and insert fails. Smaller files are
inserted OK
Any idea how to load 6 MB file to a bytea field or avoid out-of memory error
?
Is it possible to add data to a single bytea field incrementally using
separate insert of update
statements each adding for example 100 KB of data ?
Or is there other solution ?
Andrus.