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.
